Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Really need some help with a multi conditional SumProduct
All,
I have a big spreadsheet and I would like to sum a column if it meets criteria, =SUMPRODUCT((DATA!B:B=Profiling!C4)*(DATA!D:D=C12) *(DATA!K1:AX1="2012")*(DATA!K2:AX2="05B")*(DATA!A1 :AX2000)) Challenges: The first two criteria are column based The second two are row based The sumproduct range is quite large I have tried many different version of the above with an index etc. but I am always getting a 0 response and I cant seem to get it to work Any help would be greatly appreciated Thanks so much in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Really need some help with a multi conditional SumProduct
Try,
=SUMPRODUCT((DATA!B1:B2000=Profiling!C4)*(DATA!D1: D2000=C12)*(DATA!K1:AX1="2012")*(DATA!K2:AX2="05B" )*(DATA!A1:AX2000)) On Wednesday, July 9, 2014 9:40:36 AM UTC+5:30, Keelin George wrote: All, I have a big spreadsheet and I would like to sum a column if it meets criteria, =SUMPRODUCT((DATA!B:B=Profiling!C4)*(DATA!D:D=C12) *(DATA!K1:AX1="2012")*(DATA!K2:AX2="05B")*(DATA!A1 :AX2000)) Challenges: The first two criteria are column based The second two are row based The sumproduct range is quite large I have tried many different version of the above with an index etc. but I am always getting a 0 response and I cant seem to get it to work Any help would be greatly appreciated Thanks so much in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
multi-array sumproduct | Excel Worksheet Functions | |||
Multi column sumproduct | Excel Worksheet Functions | |||
a multi-rounded sumproduct | Excel Worksheet Functions | |||
SUMPRODUCT + multi conditions | Excel Worksheet Functions | |||
Multi-conditions with SUMPRODUCT and COUNTIF | Excel Worksheet Functions |