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