Link to home
Start Free TrialLog in
Avatar of Matt Pinkston
Matt Pinkston

asked on

Excel Countif ?

I have a tab called totals and have a row labeled users that have not accessed in 21 or more days... how do I get the count of all records in tab data where column H=Yes and the date in column F is more than 14 days old

using countif
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image
users that have not accessed in 21 or more days

and the date in column F is more than 14 days old

i guess you mean 21 days instead of 14 days?

anyway, you can try something like:

=COUNTIFS(data!H:H,"Yes",data!F:F,"<=" & TODAY()-21)

Open in new window

29076897.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Matt Pinkston
Matt Pinkston

ASKER

thanks