SUMIFs with criteria for > Greater & < Less than

[Sphinx404]

Greetings Experts,

I am currently working with SUMIFS and cannot seem to get my criteria to work.

U:U Column = # of days the Alert has been opened (0 to infinity)
H:H Column = Process Group (Logistics, Supply Chain, Engineering, Fabrication, Assembly)
I:I Column = Alert Status (Open/Closed)

I'm trying to write formula that will tell me the number of alerts that were "Closed" in less than 90 days.

This formula tells me the TOTAL # of Days Open for each group, summing all of column U up, but I cannot stop getting errors when adding in my < less than criteria.

Any help would be appreciated.

 

[Sphinx404]

I think this will work....?

I shouldn't be using SUMIFS I don't think.

=COUNTIFS(H:H,"Logistics",I:I,"Closed",U:U,"<"&90)