Sumproduct problem

I am trying to use the following formula to bring back the total value

=SUMPRODUCT((PayRec="Payable")*(Entity="HBAP")*(Age="0-5"),Value)

When I put this into a 'Dummy' workbook it works fine but when I put it in the 'Actual' workbook it returns #VALUE!

when I use =SUMPRODUCT((PayRec="Payable")*(Entity="HBAP")*(Age="0-5") it works fine in both the 'Dummy' workbook and 'Actual' workbook.

Please help
JagwarmanAsked:
Who is Participating?
 
Rgonzo1971Commented:
Hi,

Maybe Value is not the same size as Payrec Entity or Age

Regards
0
 
JagwarmanAuthor Commented:
Thanks Rgonzo that's exactly what it was. But, how on earth does that change I set them all to the same and I did nothing to the spreadsheet and now they are nothing like the numbers I set them to.
0
 
JagwarmanAuthor Commented:
This man is Ace.
0
 
JagwarmanAuthor Commented:
I should have said person could be a lady :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.