countIF?

[Guest]

H

Any way to get a continous RUNNING TOTAL when using a COUNTIF formual

EXAMPL
a1=c i want f1 to countif C if a1 f1 to look like
a2=c i want f2 to countif a2 for C and add a1 c f2 to look like
a3= f3 to look like
a4=c f4 to look like
a5= f5 to look like

Thanks in advanc
Gam

 

[J.E. McGimpsey]

one way:

F1: =COUNTIF(A$1:A1,"c")

and copy down.

 

[Guest]

Thanks J

Worked perfect