sum of production hours depends on the months

[sdsurzh]

Hi,


I want to sum all the production hours, present days and no of working days for a particular month. I have briefly explained in attachment.


http://www.2shared.com/document/9cTqJACO/1_online.html


Thanks,

Suresh Kumar S

 

[Faseeh]

Hi Suresh,


For Hrs :

=SUMPRODUCT((MONTH($A$2:$A$39)=MONTH(H6))*$B$2:$B$39)


For Days present:

[code]=SUMPRODUCT((MONTH($A$2:$A$39)=MONTH(H5))*($B$2:$B$39>0))

For # of days:

=SUMPRODUCT((MONTH($A$2:$A$39)=MONTH(H5))*($A$2:$A$39>0))[/code]


Drag down.


Regards,

 

[sdsurzh]

Thanks Excel Hero Faseeh,


Even i tried sumproduct but instead of month i used text formula.


Thanks,

Suresh Kumar s

 

[Faseeh]

You are welcome


Faseeh