ExcelBanter - Need help with Counting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Need help with Counting (https://www.excelbanter.com/excel-discussion-misc-queries/210035-need-help-counting.html)

Need help with sumif

Need help with Counting

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

Peo Sjoblom[_2_]

Need help with Counting

=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

"Need help with sumif" wrote
in message ...
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

All times are GMT +1. The time now is 07:29 PM.