sumif with multiple conditions

  • Thread starter Thread starter Ray
  • Start date Start date
R

Ray

I have three columns: a, b & c and need sum the figures on c if a = week1
and b = empty. Can someone suggest a formula to resolve this issue.

Thanks,

Ray
 
=SUMPRODUCT(--(A1:A100="week1"),--(B1:B100=""),C1:C100)

or a little slower:

=SUMPRODUCT((A1:A100="week1")*(B1:B100="")*C1:C100)

Regards,
KL
 
KL,

Thanks for your useful suggestion. Is it possible to apply to countif
function as well?

Thanks,

Ray
 
I guess you meant SUMIF. Don't think so, SUMIF takes only 3 arguments.
Regards,
KL
 
KL,

No, I mean the same syntax is applied to countif. It seems not workable!

Ray
 
Is this what you mean?

=SUMPRODUCT(--(A1:A100="week1"),--(B1:B100=""))
 
Ray,

I guess Bob and Domenic have answered your question ;-) It is workable.

Regards,
KL
 
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

countif 3
SUMIFS, one criteria range, multiple criteria 3
sumifs multiple columns help 1
SUMIF with criteria "<>" & "=" 4
SUMIFs across multiple sheets 7
sumif with multiple sums 3
Can I have two conditions in a SUMIF? 5
If( AND( with VLOOKUP.... 4

Back
Top