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

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

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,382
Messages
5,624,367
Members
416,025
Latest member
VN5968

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