Analysing Data between multiple ranges

  • 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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!