Need help with Counting

  • Thread starter Need help with sumif
  • Start date
N

Need help with sumif

I'm trying to figure out the percentage of good and bad

Column A are kinds of fruites
Column B Good or Bad

How do I look for Only "Apple" in Column A and figure out good ones in
percentage
 
P

Peo Sjoblom

=SUMPRODUCT(--(A2:A100="Apple"),--(B2:B100="Good"))

will give you the number of good apples, you should be able to use that
formula as part of the percentage
formula if you have at least some rudimentary math skills.


--


Regards,


Peo Sjoblom
 
Top