binduchekuri
New Member
- Joined
- Sep 27, 2020
- Messages
- 5
- Office Version
- 2016
- Platform
- Windows
I have an excel with dates in columns from jan to dec and I have a formula which need to change with corresponding date
=SUBTOTAL(102,AW_MainTable[[#All],[02/01/23]])-SUMPRODUCT(SUBTOTAL(3,INDIRECT(B9&ROW(3:7)))*(B3:B7=0))
My table name is AW_MaintTable
=SUBTOTAL(102,AW_MainTable[[#All],[02/01/23]])-SUMPRODUCT(SUBTOTAL(3,INDIRECT(B9&ROW(3:7)))*(B3:B7=0))
My table name is AW_MaintTable