need help

[elo0707]

I am trying create an if statement whereby  Column AH, row 4, computes total expense YTD depending on the quarterly date on C1, so that the following is done….

• If C1= 03/31/2023, Column AH, row 4 will sum only column S4
• If C1= 06/30/2023, Column AH, row 4 will sum only column S4 & V4
• If C1= 09/30/2023, Column AH, row 4 will sum only column S4,V4, and Y4
• If C1= 012/31/2023, Column AH, row 4 will sum only column S4,V4,Y4, and AB4

(SEE ATTACHED) specifically “TAB TOTAL EXPENS

[#2]

@elo0707 

For example:

=CHOOSE(MONTH($C$1)/3,S4,S4+V4,S4+V4+Y4,S4+V4+Y4+AB4)

or

=S4+(MONTH($C$1)>5)*V4+(MONTH($C$1)>8)*Y4+(MONTH($C$1)>11)*AB4

Remark: please correct the date in Input!B15

[#3]

Hans
-- Thank you so much. I will be implementing the choose formula.