atuljadhavnetafim
Active Member
- Joined
- Apr 7, 2012
- Messages
- 341
- Office Version
- 365
- Platform
- Windows
Dear Expert
i need formula in C13, F13 and I13 based on the month mentionioned in Row No 3.
Case 1: in C3 June-22 month mentioned then i need sum May-22 to June-22 (C6 to C7)
Case 2: In F3 Aug-22 month mentioned then i need sum May-22 to Aug-22 (F6 to F9)
Case 3: in I3 Dec-22 month mentioned then i need sum May-22 to Dec-22 (I6 to I11)
if i change the month then total should be change accordigly month mentioned in tow 3.
please help.
i need formula in C13, F13 and I13 based on the month mentionioned in Row No 3.
Case 1: in C3 June-22 month mentioned then i need sum May-22 to June-22 (C6 to C7)
Case 2: In F3 Aug-22 month mentioned then i need sum May-22 to Aug-22 (F6 to F9)
Case 3: in I3 Dec-22 month mentioned then i need sum May-22 to Dec-22 (I6 to I11)
if i change the month then total should be change accordigly month mentioned in tow 3.
please help.