I am doing a summary table which references another page with VLOOKUP formula responses.

Currently using `=SUM('CURRENT'!$J:$J)`

to calculate the total numerical values in column J, however there are some values which are #N/A as there is no source data.

This then returns no sum total calculations.

I was wondering the best way to incorporate the IF formula into a SUM formula