LinkBack URL
About LinkBacks
fabrecass 
hi guys, i have a column of planned dates (a), and a column of actual dates (b), i need to know what percentage of the actual dates are on time.
I also need a count of how many are on time.
can anyone help?
hi guys, i have a column of planned dates (a), and a column of actual dates (b), i need to know what percentage of the actual dates are on time.
I also need a count of how many are on time.
can anyone help?
Last edited by fabrecass; 01-14-2013 at 11:07 AM.
hi fabrecass. assuming data is in A2:B10, try this for %:
=SUMPRODUCT(--(A2:A10>B2:B10))/ROWS(A2:A10)
and this for counts:
=SUMPRODUCT(--(A2:A10>B2:B10))
Last edited by benishiryo; 01-14-2013 at 10:42 AM. Reason: added file
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
In C1 and copy down.
=IF(COUNTIF($A$2:$A$10,B2)>0,1,"")
The sum of(c2:c10) is the count that you are looking.
For %
=SUM(C2:C10)/COUNT(A2:A10)
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.
not having any luck with either guys.
first solution seems to just count, not count the dates on time.
second solution gives a #NAME error?
Why? ..............
oooh.... might be my mistake, does sumproduct not work across 2 worksheets?
[QUOTE=fabrecass;3081118]oooh.... might be my mistake, does sumproduct not work across 2 worksheets?[/QUOTE
It works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks