Forum Discussion
Solved
Sumif prior to current month
Hi there, Please see image below. I am trying to have column B sum if the month in row 2 is prior to current month today. Example it's currently April so I want it to sum only till April and not ...
(next times please provide Excel version + Operating system => Welcome to your Excel discussion space!)
in B3:
=IF(MONTH(TODAY())=1, 0, SUM(OFFSET(B3,,1,,MATCH(TEXT(TODAY(),"MMMM"),C$2:N$2,0)-1)))Other option with Excel 2021/365:
=IF( MONTH(TODAY())=1, 0, SUM(C3:XLOOKUP(TEXT(EDATE(TODAY(),-1),"MMMM"),C$2:N$2,C3:N3)) )
(next times please provide Excel version + Operating system => Welcome to your Excel discussion space!)
in B3:
=IF(MONTH(TODAY())=1, 0, SUM(OFFSET(B3,,1,,MATCH(TEXT(TODAY(),"MMMM"),C$2:N$2,0)-1)))
Other option with Excel 2021/365:
=IF(
MONTH(TODAY())=1, 0,
SUM(C3:XLOOKUP(TEXT(EDATE(TODAY(),-1),"MMMM"),C$2:N$2,C3:N3))
)
Amazing, thank you so much!!
- Glad you have a solution & Thanks for providing feedback