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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ladynole - 27 Sep 2005 19:56 GMT

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

Reply to this Message

Alan - 27 Sep 2005 21:35 GMT

Try
=COUNTIF(G9:G24,"Yes")
Regards,
Alan.

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

Reply to this Message

Bernie Deitrick - 27 Sep 2005 21:59 GMT

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

HTH,
Bernie
MS Excel MVP

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

Reply to this Message

ladynole - 30 Sep 2005 15:26 GMT

Thank you very much. It worked like a charm.

> =COUNTIF(G9:G10,"Yes")+COUNTIF(G12:G14,"Yes") + COUNTIF(G18,"Yes")+
> COUNTIF(G24,"Yes")
[quoted text clipped - 7 lines]
> > from the following cells,G9,G10,G12,G13,G14,G18,G24 .. appreciate the
> > help..

Reply to this Message

aka excel - 28 Sep 2005 17:15 GMT

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

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

Reply to this Message