Figures based on month selection

[Salamullah]

Hi Experts - Please give any formula

I want to get the figures in row 3 for each month based on selection of month in cell A1 as per the given example below, in Mar and Apr figures are showing zero
Suppose if I select Mar in A1 only Apr should show zero rest of the months should take sum from array F6:G11

Feb
	Jan	Feb	Mar	Apr
Sales	200	400	0	0
					Month	Sales
					Jan	200
					Feb	100
					Feb	300
					Mar	500
					Mar	100
					Apr	1000

<tbody>
</tbody>

 

[PCL]

if I select Mar in A1 only Apr should show zero and not May, June etc ...?

 

[PCL]

Let's assume data Month/sales is in range K2 to L15
Months name are in range O1 : O12 = Jan, Feb, MAr ...Nov, Dec
B4 = =IF(MATCH(B2,$O$1:$O$12,0)<=MATCH($A$1,$O$1:$O$12,0),SUMPRODUCT(($K$2:$K$15=B2)*($L$2:$L$15)),0)
Copy and paste until the last column of display .. E4

 

[Salamullah]

Excellent !! PCL Formula given is perfect thanks

Best Regards.

 

[Salamullah]

I have used the below with your given formula, only the issue its giving FALSE instead of Zero. What I am missing ?

Feb
	Jan	Feb	Mar	Apr	May
Sales	1,239,737	2,793,474	FALSE	FALSE	FALSE

<colgroup><col><col span="5"></colgroup><tbody>
</tbody>

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=IF(MATCH(E5,$E$5:$P$5,0)<=MATCH($A$3,$E$5:$P$5,0),SUMIFS(Table_Query_from_TB3[SDITVL],Table_Query_from_TB3[Month],E$5,Table_Query_from_TB3[SDAN8],Sales!$F$8))

[/FONT]

 

[higrm]

=IF(MATCH(E5,$E$5:$P$5,0)<=MATCH($A$3,$E$5:$P$5,0),SUMIFS(Table_Query_from_TB3[SDITVL],Table_Query_from_TB3[Month],E$5,Table_Query_from_TB3[SDAN8],Sales!$F$8),0)

 

[Salamullah]

Go it thanks

 

[PCL]

It seems was missing the end of the formula when you copied it...!
You know that instead of using text for month name ( e.g. Jan, Feb ...) you coukd use date ( 1/1/2019) and format the cell to display only the month: Custom Format Type "mmm"
It will be more simple.

 

[Salamullah]

Hi PCL thanks for help