Count on find

[bhavesh78]

I have a "Total" cell that appears multiple times in column A. Is there a way to code which will tell how many times "Total" exists in column A?

Thanks.

 

[PaddyD]

countif(a:a,"Total")

 

[XLGibbs]

=COUNTIF(A1:A1000,"Total")

change the range to suit.