Formula help needed for available manpower and working hour calculation.

Hi,

I trying to set few functions that will help me to calculate following things.

Excel.jpg

From column G, only Morning, Overnight and Evening Shift will be counted. All calculation needed on day basis. So, would you please help me to fix that.

Regards
Rinko

Try the following in G20 and copy down as needed:

=SUM(COUNTIFS($A$2:$A$18,A20,$G$2:$G$18,{"Morning","Overnight","Evening"}))

Does that give you what you're after?

Hello DMD,

Thank You, This is right. I need few more help. I can't count work hours. Would you please help for this. how I can also count working hours.

Thank You
Rinko

You can use SUMIFS instead of COUNTIFS for a total of your work hours.

Formula:

Please Login or Register  to view this content.

Should hopefully work.

hello DMTD,

Yap.. Thank You so so much. It is working. Thank You againg.

Best,
RInko