• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 120
  • Last Modified:

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
0
Jagwarman
Asked:
Jagwarman
  • 3
1 Solution
 
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now