Is there anything more powerful than COUNTIFS?

excelos

Active Member
Joined
Sep 25, 2011
Messages
366
Office Version
  1. 365
Platform
  1. Windows
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?
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Jeffrey Mahoney

Well-known Member
Joined
May 31, 2015
Messages
1,830
Office Version
  1. 365
Platform
  1. Windows
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

Board Regular
Joined
Aug 22, 2018
Messages
52
Add a new column that has that MAX(...)>50 formula in each cell, then use the new column as a criterion.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,098
Messages
5,622,683
Members
415,920
Latest member
ExcelNoob28

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top