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.