Combine COUNTIFS statement with SUMPRODUCT formula

[Brendan89]

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?

 

[Brendan89]

Re: How To ... Combine COUNTIFS statement with SUMPRODUCT formula

Hi, do you want a count of the rows where the date is < 30 days from today and the value in same row in column G is one of "Identified","Assessed","Planned","In-Process"?

Hello,

No not quite what I was looking to do, the Date check older than 30 days is column H and the value to match for the count ("Identified","Assessed","Planned","In-Process") is Column G.

 

[FormR]

Re: How To ... Combine COUNTIFS statement with SUMPRODUCT formula

No not quite

Hi, not sure which bit wasn't quite right, but I'm fairly sure you want the SUM(COUNTIFS(.. formula from post #5 .