B bhavesh78 New Member Joined Apr 30, 2005 Messages 36 Dec 12, 2005 #1 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.
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.
XLGibbs Well-known Member Joined Feb 25, 2005 Messages 2,446 Dec 12, 2005 #3 =COUNTIF(A1:A1000,"Total") change the range to suit.