So, I have a formula that returns a total amount of dates that are older than 30 days:
=SUMPRODUCT(--ISNUMBER(Risks!H3:H1000),--(Risks!H3:H1000<TODAY()-30))
This works great, however I also need to combine a COUNTIFS statement so it only checks for the date if certain criteria matches in another column (G).
=COUNTIFS(Risks!G3:G1000,{"Identified","Assessed","Planned","In-Process"})
I have no idea how to combine these into one formula to do this at the same time? Can anyone help?
=SUMPRODUCT(--ISNUMBER(Risks!H3:H1000),--(Risks!H3:H1000<TODAY()-30))
This works great, however I also need to combine a COUNTIFS statement so it only checks for the date if certain criteria matches in another column (G).
=COUNTIFS(Risks!G3:G1000,{"Identified","Assessed","Planned","In-Process"})
I have no idea how to combine these into one formula to do this at the same time? Can anyone help?