well, this could be an option...
=IF(K4>0;COUNTIFS(C$2:C$10;C4;K$2:K$10;">0";H$2:H$10;H4);IF(L4>0;COUNTIFS(C$2:C$10;C4;L$2:L$10;">0";H$2:H$10;H4);""))
but it starts counting if the project name, task name and start date are the same; if you do not want to take into accout the start date, just remove the red refferences from formula..
there are 2 alternatives, in sheet 1 and sheet 2, attached.
|