Adding a column that used X's

[Guest]

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.

 

[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

 

[Bob Phillips]

=COUNTIFA:A,"X")

--

HTH

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