Formula error

[Zak]

Hi,

I have the following formula, it works fine on all my columns besides the
below two. I dont understand why its not working, all figures are in place, i
have copied from the other columns so all same conventions. I'm just baffled
- please can you help?

These are the two that done work. It just says 'value' in the cell.


=SUMPRODUCT(($B$2:$B$231=$C$245)*(E2:E231<0)*E2:E231)

=SUMPRODUCT(($B$2:$B$231=$C$245)*(F2:F231<0)*F2:F231)


I tried to trace the error and i think it said something about C245 but that
shouldnt be a problem. C245 is a word which it looks up in the B range. it
worked fine all other days/months and even in this spreadsheet it works for
all besides these two. i have tried to copy in the code again from scratch
but no luck.

Many thanks,

 

[PCLIVE]

So what happens? Do you get an error? If so, what error? Are there any
errors (#N/A, #VALUE, etc.) in you data B2:B231 or E2:E231?

Regards,
Paul

 

[Zak]

Hi,

Thats the thing there is no error or null value in the data it is reading,
all the data is absolutely fine. i even copy the forumla from the two columsn
on the othree side but still get the same thing.

i just see 'VALUE' in the cell where i should see my figure. i have checked
all the figures many times and they are all fine.

can this be an excel thing, maybe playing up? i dont understand why its not
working.

many thanks.