How to get values from a table until certain date

[farrusete]

Hi,

Im trying to sum values from a row until column named with the limit date (month in current year) manually entered in a cell. Maybe attached file is clearer than me... sorry

Thank you in advance,

 

[chirayu]

Where is the raw data? its just a table with totals.

 

[Hui]

F10: =SUM(OFFSET(B6,,1,1,C$2))
Copy down

 

[bosco_yip]

Maybe,

In B10, Copy down :

=SUM(OFFSET(B$5,MATCH(LEFT(C10,FIND(" ",C10)-1),B$6:B$7,0),1,,C$2))

Regards

 

[farrusete]

Thank you so much

 

[Somendra Misra]

Hi,

Just another option:

=SUM($C6:INDEX($C6:$N6,MATCH($C$2,INDEX(MONTH($C$5:$N$5),),0)))

Copy Down.

Regards,

 

[farrusete]

hmmmmm im trying to figure out if there is a way to use SUMIFS instead of SUM to get just values with certain conditions (edited excel attached).

Thanks again

 

[Somendra Misra]

hmmmmm im trying to figure out if there is a way to use SUMIFS instead of SUM to get just values with certain conditions (edited excel attached).

Thanks again

There are multiple revenue and cost for a country, which revenue or cost to select? Is there a criteria for that?

Regards,

 

[farrusete]

Hi Somendra,

The point is to sum all revenue lines. In the xls it would be to sum 3 revenue lines for USA until october but it has to be dynamic. If i enter month number 3 and select "Cost" and "EU" it should sum all cost llines from EU (2 lines) from january to march.

Thanks again

 

[Somendra Misra]

Hi Somendra,

The point is to sum all revenue lines. In the xls it would be to sum 3 revenue lines for USA until october but it has to be dynamic. If i enter month number 3 and select "Cost" and "EU" it should sum all cost llines from EU (2 lines) from january to march.

Thanks again

Here is one option:
=SUMPRODUCT(($B$7:$B$16=$C$3)*($C$7:$C$16=$C$1)*(MONTH($D$6:$O$6)<=$C$2)*$D$7:$O$16)

Regards,

 

[farrusete]

Thank you again Somendra!