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