Sum with muliple criteria

[bhasoriya]

Hello Friends,

Need your help for sum with multiple criteria. It is difficult to describe here. So i have uploaded here excel file..

Thank you all.

 

[Xiq]

Hi there,
See attached file.

I needed a helper-column to get it to work. Then I gave you two options: one that shows BLANK and another ZERO when there is no "processed file" on that row.

 

[bhasoriya]

Hello Xiq,

Your efforts are too good but "helper column" extend my efforts a lot..
Total time spent v1 & v2 is also good..

Can't we skip the helper column?

 

[Xiq]

Hi there,
See again attached file.

After a few more moments, I was able to get to a solution without a helper column.

PS: Keep in mind that I used a fixed reference "$E$4:$E$8", you need this to edit to your own needs

 

[bhasoriya]

Thanks Xiq, It works.. Thanks a lot..