Good day to all.
I am using the following formula to add up figures entered in G2, H2, I2 and J2 if the month entered in B2, C2, D2, and E2 are the current month which is May. =SUM(IF(MONTH(B2:C2:D2:E2)=5,G2:H2:I2:J2,0)). This is working just fine except for one small thing. If I want to use this workbook next month I need to change the "=5" to "=6" to apply the calculation for June only. So when I open this workbook next month it must automatically change to add up only June's values.
Thank you.
Lukas.
Bookmarks