Sum difference cell range based on single criteria

[philipmartin]

What formula can I use to sum year-to-date data when I update the "Current Month" as my criteria?


Current Month: MAR

JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC	YTD Total
100	150	150	100	100	150	150	100	100	150	150	100	??

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

My "YTD Total" result for MAR would be 400.

If I changed current month to May, my result should be 600.

 

[SteveO59L]

are the entries formatted dates, rather than text?

or

if you don't mind adding another row for a running total (which could be hidden)

 

[philipmartin]

I could do the second option, but was hoping there might be a clean formula I just couldn’t think of.

 

[FDibbins]

Try this...

A​

B​

C​

D​

E​

F​

G​

H​

I​

J​

K​

L​

M​

1​

Current Month:

May

2​

JAN

FEB

MAR

APR

MAY

JUN

JUL

AUG

SEP

OCT

NOV

DEC

YTD Total

3​

100​

150​

150​

100​

100​

150​

150​

100​

100​

150​

150​

100​

600​

M3=SUM(A3:INDEX($B$3:$L$3,MATCH($B$1,$A$2:$L$2,0)-1))

 

[philipmartin]

It works! You guys are geniuses, thanks!

 

[FDibbins]

Thanks for the kind words (it helps if you know what tools to use lol)