formula help

[Dinesh_Excel]

Hi Friends,

I am trying to find a solution where I need an output for efforts upon satisfying two conditions.

Date wise picking up efforts in the output box as per the time lines against employee ID.

 

[NARAYANK991]

Hi ,

See if this is OK.

Narayan

 

[Ramesh]

The example shared by Narayan in the previous post is one way of achieving this and the 2nd way of achieving the required output is by using SUMIFS function..

Here is the attached updated file...

 

[Dinesh_Excel]

Thank you Both for your help. Highly appreciated