I am trying to calculate a total of a supplier between 2 dates. The total must fall in between the entered dates but the dates can be any given date and not limited to the dates in the supplied list. See attached scaled down example?
Grateful for some help as I am stuck. I tried advanced filter but I got stuck on the variable dates.
Hopefully it can be solved via a formula?
Thanks
Last edited by reddwarf; 10-12-2009 at 05:16 PM.
One approach: DSUM function
Other Options: SUMPRODUCT
=SUMPRODUCT(--(A5:A28=A2)*(B5:B28>=B2)*(C5:C28<=C2)*(D5:D28))
or Pivot Table
Edit: attachment removed at OP's request
Last edited by Palmetto; 10-12-2009 at 06:24 PM. Reason: file removed at OP's request
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
sumproduct approach worked a treat! Thanks for other suggestions.
I would have never worked that out - many thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks