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

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