LinkBack URL
About LinkBacks
trying to workout a countif where...
If column A:A in Sheet2 is = to A2 Sheet1
and if column B:B in Sheet2 is = or within 7 days greater than B2 Sheet1
trying to workout a countif where...
If column A:A in Sheet2 is = to A2 Sheet1
and if column B:B in Sheet2 is = or within 7 days greater than B2 Sheet1
Would something like this work?
=COUNTIFS(Sheet2!A:A,Sheet1!A2,Sheet2!B:B,">="&Sheet1!B2,Sheet2!B:B,"<="&Sheet1!B2+7)
- Moo
Last edited by Moo the Dog; 06-19-2015 at 04:26 PM.
=COUNTIFS(Sheet2!A:A,Sheet1!A2,Sheet2!B:B,"<=" & Sheet1!B2+7)
Both worked. thank you very much!
Glad to help. However, I do not believe JohnTopley's solution will always give correct results, because it is including every result that is <= B2+7, instead of what you originally asked: results that are >=B2 AND <= B2+7.
JohnTopley's only accounts for the "less than or equal to" B2+7, which will definitely include dates prior to B2.
Just something to watch out for...
- Moo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks