Hello everyone!

Happy new year !!!!

I am trying to avoid collect and move information manually and I am sure there is a formula that can help me do this procedure, based on the column criteria.

I need a formula that will take information from Column "H" only if there is a "YES" an move it to a separate column "K", easy to calculate at the en of the month/year. The other formula, perhaps will be same and it is data on column "H" to column "L" if the cell = "NO". This formula most contain a criteria to ad "zero" in case the space is blank.

Thank you in advanced!

See attachment

CalejobeSample Excel Forumv2.xlsxSample Excel Forumv2.xlsxSample Excel Forumv2.xlsx