| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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.. |
|
#2
|
|||
|
|||
|
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.. |
|
#3
|
|||
|
|||
|
=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.. |
|
#4
|
|||
|
|||
|
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.. |
|
#5
|
|||
|
|||
|
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.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
| How to use macros to copy a range of cells which can exclude some cells which I didn't want to be copied? | Excel Worksheet Functions | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Counting empty cells within a range of cells | New Users to Excel | |||
| Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
Linear Mode
