Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT WITH A VARIABLE CRITERIA?
HI, I WOULD DO SOMETHING LIKE THIS:
=SUMPRODUCT(--(A2:A500="x"),--(B2:B500=D1),C2:C500) WHERE (CELL)D1 IS VARIABLE THAT I INTRODUCE THANKS IN ADVANCE |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sumproduct with one variable criteria? | Excel Worksheet Functions | |||
SUMPRODUCT Criteria Via Cell Reference?? | Excel Worksheet Functions | |||
Aling multiple sets of data by header column | Excel Discussion (Misc queries) | |||
Multiple Criteria in SumProduct, N/A Result | Excel Worksheet Functions | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |