B bhasoriya Member Sep 25, 2013 #1 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. Attachments _N.jpg & _T.jpg conversion..xlsx 10.7 KB · Views: 5
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 Active Member Sep 25, 2013 #2 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. Attachments _N.jpg & _T.jpg conversion..xlsx 12 KB · Views: 3
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.
B bhasoriya Member Sep 25, 2013 #3 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?
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 Active Member Sep 25, 2013 #4 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 Attachments _N.jpg & _T.jpg conversion.xlsx 11.7 KB · Views: 2
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
