Make Countif Work Like Sumif

  • Thread starter Thread starter MARI
  • Start date Start date
M

MARI

I need to have multiple condition for countif function,
similar to sum wizard. is there any way to do this?

thanks
 
Hi
try (if you want to check column A and B for a condition)
=SUMPRODUCT((A1:A100="cond_1")*(B1:B100="cond_2"))
 
You need something different for multiconditional counting. For example:

=SUMPRODUCT(--($A$2:$A$10="X"),--($B$2:$B$10="Y"))

gives a count of co-occurrences of X and Y.
 
HEY, worked GREAT! I seem to be able to do it for more
than 2 conditions, too--YOU'VE MADE MY DAY! Thanks so
much, you are awsome!
 
Frank,

Thank you so much for responding so fast. Unfortunately, I
can not figure it out. It is not working for me, but
luckily another reply seems to work for me. Thanks again!

mari
 
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

SUMIF with criteria "<>" & "=" 4
Combine Sumif and Countif 3
countifs with multiple dates 2
Sumif / Countif 6
How do I use countif like sumif ie (range,criteria,count_range) 1
counting multiple dates in a range 1
Copying and pasting with SUMIF and COUNTIF 3
#DIV/O! Error 5

Back
Top