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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT WITH A VARIABLE CRITERIA?
Cif,
See all answers to your previous post ... If I may repeat myself, what is the precise problem you are facing ? Carim |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMPRODUCT WITH A VARIABLE CRITERIA?
You said earlier that it worked, but you need use a separator of ; not
comma. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Cif" wrote in message ... 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 |
Reply |
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 |