Help with two Criterias Formula

Hello All,

I've been trying to perform a productivity report but I have problem with a formula that has to verify the date as the first criteria.

This is the story, I receive a weekly report from 20 workers with the following informationis in the general table in the attached excel file)
1- Data
2-Initials
3-Data
4-total Field
5-Total time

Then I have to summirize it which was easy to do but also want to be able to do it by day of the week starting from Wednsday to Monday, I can't find a formula that work.

Can any one take a look at this and help me or point me to the right direccion?

I really appreciate any help

Hi,

See the attached file.

E5: =COUNTIF($F$16:$F$78,E$4)
E6: =SUMIF($F$16:$F$78,E$4,$D$16:$D$78)
E7: =COUNTIFS($C$17:$C$78,"1",$F$17:$F$78,E$4)
E8: =COUNTIFS($C$17:$C$78,"2",$F$17:$F$78,E$4)
E9: =COUNTIFS($C$17:$C$78,"3",$F$17:$F$78,E$4)
E10: =COUNTIFS($C$17:$C$78,"4",$F$17:$F$78,E$4)
E11: =SUMIF($F$16:$F$78,E$4,$E$16:$E$78)
E12: =AVERAGE(E11/E5)

Hello Benishiryo,

Thank you very much for the spelling error, is better you pointing it out than my boss she will be
Thank you for the formulas and the time you spend on it, your response were very quick and i really appreciate it, only tha the function for the total time return zero, if you can take a look at that?
But again thank you very much.

Sincerely,

Alex

Hello, Cbatrody,

Thank you for your quick response and the time helping me, only one question, the columm you add with the day of the week, do i need to add it to the other reports, I don't have it in the report I get from the employee but its no bad to have it if it can be done automatically which i might be able to do.

Thanks again, but solutions work beautifull yours and the one from Benishiryo, sure my boss will thank you too, I hope

Hi Alex,

Yes and there is formula to convert the date into Days in text format.

Hi Cbarody,

Great, I can do that using a macro.

Thanks again.

Respectfully,

Alex

Hello Benishiryo,

Yes, that was the problem.

thank you very much!

Respectfully,

Alex

Hello Moderator,

I'm back with one more problem with the same workbook, i don't know if I can post in this one which is mark as solved or I have to create a new one. please advice.

Respectuflly,

Alex