I know I have seen this before but cant remember the fix. We have columns A and B, then a variance column. Users dont want to suppress so sometimes there is #missing in both columns so the variance column is returning a #Error. I can change the suppression to make it - or 0 but then my totals are showing a #Error also. Isnt there a formula for this? Thanks!