I know this should be easy, but I'm having trouble setting up the formula:
I need a formula that will show me the amount of "lates" per unit for a specific date (today) from a list of dates. Please see attachment. I know this should be easy, but I keep messing it up! Time to call in the big guns!
with sumproduct.
see the green cell in the attachment.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
It's close. However, it is summing all of the "lates" for "Unit 1". I need it to be date specific and only sum the lates for the given day.
Please show me the result in your file.
Work with an color so I can see what you mean.
please see attachment. Thanks
See the orange cell.
See the attachment.
Hi Mr. H2
How about:
=COUNTIFS(A10:A16,C1,E10:E16,C3)
or
=SUMPRODUCT(--(A10:A16=C1),--(E10:E16=C3))
Regards Kevin
Merged Cells (They are the work of the devil!!!)
Perfect! Thanks for all the help!
thanks for the reply.
glad I could help.
if your question is solved, will you mark the question as solved.
you can add an rep. to the ones who helped you, by clicking on the star on the left side.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks