Hi,
Can someone please help me.
I am trying to analyse data between 2 different ranges, I have a list of customers and their invoice/ payment dates.
I have used a SUMIFS formula to group by pay date i.e 31>60;61>90 etc.
However, I would also like to add a date range as we hold a few years of data, extending the SUMIFS formula doesn't work.
In the sheet I have attached, I would like to only include the data between the date range "C3083" & "D3083"
best regards
Dave