Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct with multiple criteria
I am trying to sum a monetary value with multiple criteria.
alumni, ages 41-55 I can't seem to figure out the formula. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct with multiple criteria
Say we have in A1 thru C17:
James Smith 32 $2,335 John Johnson 53 $788 Robert Williams 36 $4,020 Michael Jones 40 $730 William Brown 52 $3,500 David Davis 45 $4,995 Richard Miller 40 $1,389 Charles Wilson 57 $3,088 Joseph Moore 51 $4,663 Thomas Taylor 40 $2,482 Christopher Anderson 45 $2,454 Daniel Thomas 46 $2,691 Paul Jackson 59 $4,798 Mark White 51 $2,763 Donald Harris 39 $572 George Martin 37 $2,113 Kenneth Thompson 30 $3,268 then the formula: =SUMPRODUCT((B1:B1740)*(B1:B17<56)*(C1:C17)) yields $21,854 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT that contains multiple criteria | Excel Worksheet Functions | |||
Multiple criteria for sumproduct | Excel Discussion (Misc queries) | |||
SUMPRODUCT / SUMIF on Multiple Worksheets with Multiple Criteria | Excel Discussion (Misc queries) | |||
SumProduct With Multiple criteria | Excel Worksheet Functions | |||
Using Sumproduct with multiple Criteria | Excel Worksheet Functions |