Error check and if the cell is not numeric or empty loop to the next item

that ain't magic ;-)

it just uses the COUNT worksheet function to make sure there are 4 numbers in the 4 cells and the COUNTIF function to make sure all 4 are greater than 0