In the attached workbook Range H100 to H104 I have a SumIf, =SUMIF(G3:G96,G100:G104,D3:D96), this works great on ALL the data.
Firstly, could this be made dynamic as the formula only works upto row 96 and my dataset will grow.
Secondly, how can I get it to only SumIf between dates, e.g. From 24 October 2021 To 05 January 2022 but by using the cell E99 & E101 references on the sheet.
Do I need VBA for this?
Bookmarks