VBANovices
New Member
- Joined
- Jan 15, 2018
- Messages
- 4
Hi I have some sheets that update daily. I have some formulas that I would like to update automatically to include the new rows but I cannot fathom how/where to set the INDIRECT. Any help greatly appreciated
The current formulas are
=COUNTIFS(Sheet1!C4:C250021,"Workington Mens", Sheet1!DI4:DI250021, ">1")
=SUBTOTAL(2,DH4:DH250021)
=SUMPRODUCT((Sheet1!DI4:DI250021>=1)*(SUBTOTAL(103,OFFSET(Sheet1!DI4,ROW(Sheet1!DI4:DI250021)-MIN(ROW(Sheet1!DI4:DI250021)),0))))
As I say I would like all the formulas to accommodate rows inserted daily at the top of the sheet Row 4 will always remain the first data row
Any help greatly appreciated
The current formulas are
=COUNTIFS(Sheet1!C4:C250021,"Workington Mens", Sheet1!DI4:DI250021, ">1")
=SUBTOTAL(2,DH4:DH250021)
=SUMPRODUCT((Sheet1!DI4:DI250021>=1)*(SUBTOTAL(103,OFFSET(Sheet1!DI4,ROW(Sheet1!DI4:DI250021)-MIN(ROW(Sheet1!DI4:DI250021)),0))))
As I say I would like all the formulas to accommodate rows inserted daily at the top of the sheet Row 4 will always remain the first data row
Any help greatly appreciated