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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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")
 
Thank you very much. It worked like a charm.

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

HTH,
Bernie
MS Excel MVP
Click to expand...
 
Back
Top