Try
=COUNTIF(G9:G24,"Yes")
Regards,
Alan.
"ladynole" wrote in message
...
need help with formula. i want the total number of cells that contain
"yes"
from the following cells,G9,G10,G12,G13,G14,G18,G24 .. appreciate the
help..