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
 
Back
Top