Collect and Move information to another tab based on the type of information (if something

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

in k4 insert

Please Login or Register  to view this content.

in l4 insert

Please Login or Register  to view this content.

then copy then down as needed

RCM,

Thank you so much !!!

you are welcome, please mark the thread as solved...