I have a spreadsheet set up with formulas set to return "n/a" when meeting certain criteria. However, when I do a sum of only "n/a"s, this results in a zero when I need to return another "n/a." The sum functions are performed on a large quantity of data with multiple sublevels so I use the subtotal function. Is there anyway to stop subtotals with only "n/a" from returning zeros without manually inputing a sumif for the numerous totals in my spreadsheet? I appreciate any help!