Quinsjim
New Member
Hello - I've been an enthusiastic lurker on this site - which has solved a whole load of headaches for me in the past, but here's a probably simple one I can't crack.
I'm trying to run a countif formula to tell me how many items are coming due in the next week - which works well
=(SUM((COUNTIF(Log!K6:K1000,TODAY()-WEEKDAY(TODAY())+{1,2,3,4,5,6,7}))))
But for some reason I cannot think how to also filter this to exclude the items which are also marked "completed". i.e. I am only interested in things coming due which are still open.
I have a column (Log!I6:I1000 which holds the variables "Open" or "Complete")
What is the formula I can't think of to do this simple validation?
Please help solve my Monday morning headache!
I'm trying to run a countif formula to tell me how many items are coming due in the next week - which works well
=(SUM((COUNTIF(Log!K6:K1000,TODAY()-WEEKDAY(TODAY())+{1,2,3,4,5,6,7}))))
But for some reason I cannot think how to also filter this to exclude the items which are also marked "completed". i.e. I am only interested in things coming due which are still open.
I have a column (Log!I6:I1000 which holds the variables "Open" or "Complete")
What is the formula I can't think of to do this simple validation?
Please help solve my Monday morning headache!