Is there anything more powerful than COUNTIFS?

[excelos]

Hello,

I want to count rows that have specific values in different columns but also for one of the columns that contains a DATE, I want to return matches for the function MAX(TODAY()-DATE,TODAY()-1/1/18)>50


Any idea how to do that?

 

[Jeffrey Mahoney]

Are you looking for the latest date within a certain number of days old and another column is greater than 50?

or the count of items with a certain number of days old and another column is greater than 50?

Jeff

 

[jjasmith4]

Add a new column that has that MAX(...)>50 formula in each cell, then use the new column as a criterion.