Adding a column that used X's

T

TJ

I have column's that I need to total. The staff uses X's not numbers. I need
to total these colums. What formula can i use. The sum function won't use X's.

Thanks in advance.
 
R

Roger Govier

Hi

=COUNTIF(A:A,"=X") will count the X's in column A
=SUMIF(A:A,"=X",B:B) will sum the values in column B that correspond with X
in column A

Regards

Roger Govier
 
B

Bob Phillips

=COUNTIFA:A,"X")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top