Really need some help with a multi conditional SumProduct

K

Keelin George

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
 
V

vijay.agarwal.1234

Try,

=SUMPRODUCT((DATA!B1:B2000=Profiling!C4)*(DATA!D1:D2000=C12)*(DATA!K1:AX1="2012")*(DATA!K2:AX2="05B")*(DATA!A1:AX2000))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with SUMPRODUCT Function 6
To sumifs or sumproduct? 2
Really need some help with a tricky formula 8
Need help with sumproduct and dynamic columns 7
Help with Complex SUMPRODUCT formula 5
Help with Sumproduct or Rank 1
need help with conditional formatting 3 criteria 2
SUMPRODUCT / SUMIF on Multiple Worksheets with Multiple Criteria 2

Top