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

=IF($J4="Yes",$H4,0)

in l4 insert

=IF($J4="No",$H4,0)

then copy then down as needed

RCM,

Thank you so much !!!

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