Thank you very much. It worked like a charm.

"Bernie Deitrick" wrote:

=COUNTIF(G9:G10,"Yes")+COUNTIF(G12:G14,"Yes") + COUNTIF(G18,"Yes")+
COUNTIF(G24,"Yes")

HTH,
Bernie
MS Excel MVP


"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..