Sumif all columns up till meeting the criteria

[kekeda]

I have the following data table:

	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep
Apple	2	3	1	5	6	3	8	1	4
Pear	5	2	7	0	8	1	2	6	7
Banana	3	6	1	5	3	9	7	8	0

Current month is June for example, then I would like to sum up for Banana line, all numbers up till Jun. That is 3+6+1+5+3+9 = 27.
Is there a formula where I can do that? Thanks!

 

[RasGhul]

Hi,
Maybe this;

Book1
	A	B	C	D	E	F	G	H	I	J
1		1/01/2021	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep
2		Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep
3	Apple	2	3	1	5	6	3	8	1	4
4	Pear	5	2	7	0	8	1	2	6	7
5	Banana	3	6	1	5	3	9	7	8	0
6
7	Start Date	1/01/2021
8	To date	1/06/2021
9	Banana	27
Sheet1

Cell Formulas
Range	Formula
C1:J1	C1	=EOMONTH(B1,0)+1
B9	B9	=SUMPRODUCT(($A$3:$A$5=$A$9)*($B$1:$J$1>=$B$7)*($B$1:$J$1<=$B$8)*$B$3:$J$5)

Cells with Data Validation
Cell	Allow	Criteria
A9	List	=$A$3:$A$5