Forum Discussion
Quentillian
Nov 23, 2024Copper Contributor
Counting Overdue Dates between two columns
Hello all, Platform: Microsoft 365 web I have been trying to create a formula for the following: On a "dashboard" I am tracking several data points from my workbook. I need my dashboard to track i...
HansVogelaar
Nov 23, 2024MVP
How about
=SUM(('Sheet Name'!$J$2:$J$1000="Name")*('Sheet Name'!$AO$2:$AO$1000>'Sheet Name'!$AN$2:$AN$1000))
where Sheet Name is the name of the sheet with the data. Adjust the ranges if necessary.
(Same as this question on answers.microsoft.com)