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.