| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| counting function but not double counting duplicates | Excel Worksheet Functions | |||
| counting help | Excel Worksheet Functions | |||
| Counting Help | Excel Worksheet Functions | |||
| Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
| Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
Linear Mode
