to exclude zeros & blanks for non-contiguous range across the same row but different columns. Using this formula I get a "spill" error. I've tried other formulas and I get "Value" error. Can someone help me with the correct formula? I'm not all that experienced...I've also attached a screenshot of my problem. Thank you in advance.