Hi,
In the attached spreadsheet I am trying to return the sum from a range of cells in cell C6 between two selected dates the date cells are C3 and C4.
Eg. In my example C6 ought to value 60,000
Thanks
TGP
Hi,
In the attached spreadsheet I am trying to return the sum from a range of cells in cell C6 between two selected dates the date cells are C3 and C4.
Eg. In my example C6 ought to value 60,000
Thanks
TGP
I think your months would need to be entered as dates formatted as "MMMM",then use SUMPRODUCT
= SUMPRODUCT((MONTHS>=C3)*(MONTHS<=C4)*(B9:B20))
Last edited by royUK; 01-31-2011 at 06:23 AM.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
If you're only ever looking forward (JUN -> DEC rather than DEC -> JUN) then:
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Hi Roy,
Do you mean:
=SUMIFS(B9:B20,MONTHS,C3,MONTHS,C4)
Also, I don't appear to have "MMMM" as an option on my date formatting? Can you point me in the right direction please.
TGP
format cell custom mmmm
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
I've changed the formula to sumproduct, "mmmm" would be a custom numberformat.
DO has posted an alternative, not sure which would be best - DO's a formula guru
[removed - wouldn't work]
Last edited by DonkeyOte; 01-31-2011 at 06:28 AM.
Hi
Thank you helping me, works perfectly for what I need.
TGP
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks