Satifying 2 criteria...then sumif

  • Thread starter Thread starter kieffer
  • Start date Start date
K

kieffer

How can I use the sumif function to do the following. I want to add the
3rd column if the 1st column = D and the 2nd colum = 1?


D 1 30
Q 1 40
R 2 50
R 2 60
Q 1 20
D 2 30
 
=sumproduct(--(a1:a10="D"),--(b1:b10=1),(c1:c10))

Adjust the range, but don't use the whole column.

=sumproduct() likes to work with numbers. The -- stuff turns true/falses to 1's
and 0's.
 
Instead of adding based on satifying 2 criteria, how can you simply
count?
 
Just take out the last argument....

=sumproduct(--(a1:a10="D"),--(b1:b10=1))
 
You must log in or register to reply here.

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 SUMIF & AND function 2
Column Average Given 2 Criteria 4
Condense data for stock ordering 4
SUMIFS, one criteria range, multiple criteria 3
Sum per row and Average per column from a second sheet. 6
New 2007 Sumifs formula - is there a new multiple criteria vlookup 2
Month wise Sum 4
question using "INDEX" and "IF" functions 1

Back
Top