Sumproduct-it is returning a 0
Hello,
I am trying to use a sumproduct formula as a lookup. Here is the formula I am trying to use
=SUMPRODUCT(('[Forecast Model.xls]Overview'!$A24:$A5000=A3),('[Forecast Model.xls]Overview'!$F24:$F5000))
Currenty it is returning a 0 which is wrong. Can someone please tell me where I am going wrong.
Thank you.
Try this,
=SUMPRODUCT(--('[Forecast Model.xls]Overview'!$A24:$A5000=A3),('[Forecast Model.xls]Overview'!$F24:$F5000))
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Hi,
Are you dealing with text or values ...?
Are you sure there is no discontinuity in your long ranges ...?
HTH
Carim
Thank you, it worked.
Can you tell me why the (--( what does that do?
Hi,
It is a double unary operator .. precisely because you are using text and not values in this column...
HTH
Carim
Take a look at this this for more explanationOriginally Posted by kelljeff
Thank you, it worked.
Can you tell me why the (--( what does that do?
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
And a Merry Christmas
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks