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.

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


TJ wrote:
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.

=COUNTIFA:A,"X")

--

HTH

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


"TJ" wrote in message
...
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.