Hey all! In my example below, I am trying to sum up 4 boxes. They contain N/A, 2, 1, and 3. I tried using the SUMIF formula to ignore (or use 0) when the cell contains N/A. However, it is returning #VALUE! when I use this formula. Is there something I'm doing wrong or a better way to do this?