How to find country first, then sum several values for this country.

[krislopmar]

I have a series of countries in cells A1:A100, each country has production for each month in columns B:M. I need a formula which sums production for a certain country (cell AA1) acumulated year to date, according to current month (1 to 12 in cell AA2). How can I do it?

 

[NARAYANK991]

Hi ,


Try this :


=SUM(OFFSET($B$2,MATCH(AA1,$A$2:$A$101,0)-1,0,1,AA2))


I have assumed that the production data is in the range B2:M101 ; the names of countries is in column A , from A2:A101. Row 1 is used for the month headers.


Narayan

 

[krislopmar]

Thanks so much Narayan, it worked perfectly!!!