Solved

Sumproduct problem

Posted on 2014-12-11
4
102 Views
Last Modified: 2014-12-11
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
Comment
Question by:Jagwarman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 51

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 40493340
Hi,

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

Regards
0
 

Author Comment

by:Jagwarman
ID: 40493355
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
 

Author Closing Comment

by:Jagwarman
ID: 40493358
This man is Ace.
0
 

Author Comment

by:Jagwarman
ID: 40493361
I should have said person could be a lady :-)
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question