Using a SumProduct Count to find a SumProduct Total?
Have successfully used SUMPRODUCT(N(YEAR($A$2:$A$15)=$E$2)) in the attached xls file to count the number of gas station visits in years 2004, 2005. I now need a total litres bought for these same years. Would appreciate a same cell working solution and explanation if anybody can think of one? Thanks!
Last edited by shg; 02-17-2010 at 03:15 PM.
Add the summation range, eg:
=SUMPRODUCT(N(YEAR($A$2:$A$15)=$E2),$B$2:$B$15)
copied to D3
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Thank you very much! That worked just fine.
Its the first time I have used SumProduct.
Be sure to check out the link in my sig. to Bob Phillips' white paper on the function - widely regarded as one of the best around.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks