Hi Excel Gurus
I need to use a SUMIF function to total a range of quotes on a table. However, the criterion that I need to use is not a single value, but a range of random quotes that is not in any particular order. Traditional use of a SUMIF function would only allow a single criterion to total values from a range of cells that you want to sum (see "Quote" field).
But how can I achieve the same thing with a criterion that is a short select range,"D2:D4", (see "Selection" column)? Is there another function I can use to produce the same result?
This is formula I'm trying to execute, but it failed:
=SUMIF(A2:A10,D2:D4,B2:B10)
The result should be $3,600
Bookmarks