Adding a columns displayed value not working

[ragingfred]

I'm having a problem with a formula recognizing a value, from a formula, in another cell.

Cell B1 checks to see if C1 starts with "free" if so change B1's value to 1.

Cell A1 sums column B.

The problem is that A1 is not adding the values of column B together.

Cell A1
=SUM(B1:B1500)

Cell B1
=IF(LEFT(C1,5)="FREE","1","0")

[icestationzbra]

hi there,

in B1, the "1" is being recorded as a text because of the quotes around it. try this instead:

=IF(LEFT(C1,5)="FREE",1,0)

also, FREE is 4 characters long, but you are extracting 5 characters from C1 and then comparing that with "FREE". are you getting any results at all?

you should share a sample workbook so that an informed and pertinent solution could be provided.

1198

[ragingfred]

You are right, Free is only 4 instead of 5, a mistake on my part. On the other hand removing the quotes did the trick.

Thank you,

Fred