so what might Col A (e.g. A1:A3) not equal ?


"CCrew2000" wrote in message
...
I forgot to mention that Column A is text. Values in column B

"JethroUK©" wrote:

=Sum(A1:A3)=x*SUM(B1:B3)


"CCrew2000" wrote in message
...
I'm trying to sum a column of data "B", but only if column "A" does
not
equal
X.