Announcement

Collapse
No announcement yet.

Analysing Data between multiple ranges

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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
    Attached Files

  • #2


    Can you manually type what kind of desired range you want to generate? I don't understand what frequency, date format and where you want to add the range to.

    Comment

    Working...
    X