SUMPRODUCT

D

DaveMoore

Good Morning.
I have never quite understood how SUMPRODUCT works but I think I need
it for my problem.
I want to sum a range in column 'O' where the corresponding cell in
column 'C' = 6011 and in column 'D' = 1 and in column 'J' = 120001261
What formula do I need?
Will SUMPRODUCT do the job?
is there another way?
My Thanks,
Dave Moore
 
M

Mike H

Hi,

Sumproduct is as good as anything else for this

=SUMPRODUCT((C1:C50=6011)*(D1:D50=1)*(J1:J50=120001261)*(O1:O50))

Mike
 

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

Sumproduct giving #Value error 5
Cumulative formula for word table 0
SUMPRODUCT help needed 7
Sumproduct Help! 3
Copy addition formula of non-consecutive horizontal cells 2
SUMPRODUCT to exclude text column header 1
Sum every Nth Row (almost working) 2
Count if data falls within a range AND that has a certain criteria 1

Top