hi guys,
I have a document with dates in column J and dates in column K, if column J is > column K then it is on time, and i have a summary to show the number of lines on time with this formula.
however, if column K is empty it states 100% on time, i realise that a populated date is greater than nothing - is there a way around this? so if column K has no dates it comes back as 0%?
Please Login or Register to view this content.
Last edited by fabrecass; 01-29-2013 at 08:29 AM.
Does this helps?
=SUMPRODUCT(--(Sheet1!J5:J5003>Sheet1!K5:K5003)*(Sheet1!K5:K5003<>""))
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.
seems to work sir! thank you very much!
rep to come!
You are welcome and thanks for the reb*
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks