Formula is not understanding me
Cell named open says this =COUNTIFS('Procurement Schedule - A'!L11:L148,"<>Closed",'Procurement Schedule - A'!F11:F148,"<" &TODAY(),'Procurement Schedule - A'!L11:L148,">0")
Cell named closed says this
=COUNTIFS('Procurement Schedule - A'!K11:K148,"=Closed",'Procurement Schedule - A'!D11:D148,"<" &TODAY())
When data is entered as closed in L11
closed adds one which is correct
but OPEN doesnt remove one which should happen too
I'm afraid you'll have to adapt your thread title per forum rules first
Your thread title did make me smile...but you need to change it like what Pepe said to be able to receive replies.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Also, there is no need to start a new thread for the same question.
http://www.excelforum.com/excel-form...-function.html
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thanks Fotis.
Shainal,
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks