Need IF Statement to yield percentages
 

Thanks -

Two Columns involved:

- Column F has text entries in the range F2:F28: (Ex: "Oranges" or "Apples")

- Column K has a general values in the range K2:K28 (Ex: "7.0.4" or "6.1.4")

I need a formula which will yield, for example, the percentage of:

- Oranges that are 7.0.4
- Apples that are 6.1.4 (obviously the difference but I need to display both).

The formulas can reside in two separate cells if necessary. Thanks again!

Need IF Statement to yield percentages
 

Hi,

Am Mon, 16 Jun 2014 20:09:42 +0100 schrieb mmurray47:

- Oranges that are 7.0.4

try:
=COUNTIFS(F2:F28,"Oranges",K2:K28,"7.0.4")/COUNTIF(F2:F28,"Oranges")
and format the cell as %


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional