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
Matt PinkstonAsked:
Who is Participating?
 
Ryan ChongConnect With a Mentor Commented:
any further clarification is needed here?
0
 
Ryan ChongCommented:
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
0
 
Matt PinkstonAuthor Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.