Sumif/Sumproduct formula to add all expenditure related to a particular item up until the selected month

[Edmond_Dantes]

Hi guys

Hope someone can help.

I need a formula that will sum all the expenditure related to a particular item up until the end of a month which is selected by the user.

The user will select the month from a dropdown list on a separate worksheet from the data. Say this dropdown lies in B3.

This is what I've got so far:
=SUMIF(Data!M:M,$B15, Data!Y:Y)
=SUMIF(Data!M:M,$B15, Data!Z:Z)
........
=SUMIF(Data!M:M,$B15, Data!AJ:AJ)

Column M in the datasheet contains a list of items, say books, dvds etc.
Column Y in the datasheet contains expenditure for April 2011, Z for May 2011 and so on
The matching item lies in B15, say "books."

I would need a single formula that will calculate all the expenditure for the item "books" up until the end of the month which the user selects.

I hope this is all clear. Any help would be appreciated.
<!-- / message -->

 

[Gerald Higgins]

When you select a month, are you looking for expenditure just in that one month, or for all months up and including that month ?

 

[Edmond_Dantes]

Hi Gerald. Thanks for the reply.

Because the financial year begins in April and ends in March, if the user had selected May for instance, then I would need expenditure for April up until the end of May.

 

[Gerald Higgins]

Is "books" or whatever item is being analysed, a single row ? or multiple rows ?