View Single Post
 
Old 08-25-2011, 08:03 AM
Catalin.B Catalin.B is offline Windows Vista Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

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.
Attached Files
File Type: xlsx Book3.xlsx (11.3 KB, 14 views)
Reply With Quote