Reputation: 63
I'm trying to pull the sum of multiple values from one Excel sheet into another based on criteria in a column. Vlookup doesn't work because it only pulls the first value, rather than multiple.
I want the sum of the values in column E (Sheet2) where Column C (Sheet2) equals Column A in Sheet 1
In B2, I want the sum of all values from Sheet2 where Column A equals 7 A.M.
Upvotes: 0
Views: 191