Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 122
  • 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
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.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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