return multiple values in 1 column via index / match

[Bax]

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

[:) Sixthsense :)]

In B8 Cell of Invoice Sheet

=SUMIF(data!B:B,B3,data!C:C)

[Bax]

Damn, that was so easy I overlooked that one....

Many thanks!
Case closed!
Star added...

[:) Sixthsense :)]

Glad it helps you and thanks for the feedback and rep

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.