Forum Discussion
need help
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 Replies
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
- Hans
-- Thank you so much. I will be implementing the choose formula.
