Hi All,
I'm searching through the forum for a solution of the below, but can't find it so far...
Attached sheet has a data tab and an invoice tab.
What I need is a formula in the Invoice tab in the blue cell B8 which looks up the value of the Invoice tab cell B3 in the Data tab column B and returns the sum of all values in column C.
So when I enter "October/2013" in B3, it should return "55" in cell B8.
When I enter "November/2013" in B3, it should return "60" in cell B8.
Seems pretty straight forward with some index / match formula, but somehow I'm stuck in getting the sum of all values...
Any ideas on this?
Many thanks!!
Peter
invoice template.xlsx
Bookmarks