LinkBack URL
About LinkBacks
Markshr 
Hi Just trying to sort out the attached, any ideas whats wrong?
PROBLEM.xls
Thanks!
Hi Just trying to sort out the attached, any ideas whats wrong?
PROBLEM.xls
Thanks!
what do you think is wrong? Seems to be adding up correctly from the quick counts I did.
rylo
Thanks for the reply,
Cell "R24" should result in the number count of "1", due to a person entering the store at that time as in cell "C21"
Thanks
Hi all,
maybe in F24:
=SUMPRODUCT(--(ROUND($C$4:$C$52,5)=ROUND(F25,5)))
It's a rounding issue, these problems are derived from the transformation from decimal to sexagesimal notation of the time: double check this info.
Regards
Last edited by canapone; 02-08-2012 at 02:04 AM.
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Brilliant, thanks
Hi,
thanks for your kind feedback.
Saluti
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks