how can i add cells that are not in a range?
 

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

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

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

Select the cells G9,G10,G12,G13,G14,G18,G24 and give it a name by typing in
the name in the name box. Then try the the formula countif("Name
given","yes")

"ladynole" wrote:

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

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