Using SUMIF i want to say IF A=1 & B=2 then sum C any help pleas

P

Peter

I want to single out a sum that has two common detonators row A and B, IF row
A=1 and row B=2 then sum row C
 
J

JBeaucaire

Try this, adjust the range to match your data:

=SUMPRODUCT(--(A1:A100=1), --(B1:B100=2), C1:C100)

Does that help?
 

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

Sum of values in column A based on 0/1 of column B 2
Tricky one 1
Sum Values from different column 1
Sum of Variable Cells in a fixed Row 3
Help with SUMIFS 2
Sum data using sumif 3
Multiple Columns in Sum Range using SUMIFS 1
Multiple Criteria Sum 8

Top