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:E2 31)

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


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,