Need help with Counting

  • Thread starter Thread starter Need help with sumif
  • Start date 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
 
=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
 
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

HDI: Show Value as 'Percentage of' Grouped Column in Pivot 2
Count the columns from one sheet and paste it in another sheet 0
Counting text which meets a criteria 2
counting cells that contain a date 3
getting a percentage 1
Strange request: Counting cells and percentages 4
Min-Max question 6
Access Group by precinct, calculate percentage of older voters 0

Back
Top