complicated summing and counting same time

[guitarist00]

hello all.

please find the attached excel sheet for what im doing
Example Statistic.xlsx


im trying to calculate the crew hours from a data base i created .

i entered the sumifs formula but i entered many argument

the block time should be calculated based on the month and to calculate only for specific name for each crew

the formula should be involve in the colorful cells only

can someone help me please ? i got stuck for couple of hours and i give up and thought to ask here for some help

thank you in advanced

regards
Hani

[[email protected]]

Please find attached excel sheet for your problem solution

Regards,
Suhas

[guitarist00]

Thx Suhas!


that what i exactly need. but for example , Matt is flying as crew 2

so N733ES Data'!$H$2:$H$29

i tried to change it to N733ES Data'!$H$2:$J$29 to count crew 1, 2 and 3

but it gave me error ( #Value!)

how can i fix it ?

regards,
Hani

[[email protected]]

PFA updated solution.

Regards,
Suhas

[guitarist00]

thx Suhas!!

i really appreciate your help !

have a great day

regards,
Hani