Formatting of numbers affecting formulas

**JakeMann** · 04-03-2013, 03:30 AM

Hi All,

I'm not sure how to resolve this issue. On the attached book, on the Data sheet, F2 contains a formula that should produce a '1'.

The formula is =IF(OR(E2=Transactions!$C$2,),COUNT(F$1:F1)+1,"")

The data it's looking at is originally from an Access table and it isn't producing a value in F2.

If I simply type the figures I need it to assess and put the same formula in I2 then it does produce the answer I want. Therefore I thought it was perhaps something to do with the formatting of the original data.

Any thoughts as to what the problem could be?

**Fotis1991** · 04-03-2013, 03:40 AM

In column D you get a text, using left function. Not a number.

So in D2 and copy down use this.

=IFERROR(LEFT(C5,4)+0,"")

In F2, this one

=IF(D2=Transactions!$C$2,COUNT(F$1:F1)+1,"")