SUM Formula
=SUMIF(C:C,"0")
"Riley" wrote:
I want to sum a range of 10 cells that already have formulas in them to auto
populate as I enter data elsewhere......If I want to sum these cells before
they have all been populated, I get a "N/A" return. Can someone tell me how
to sum these cells and ignore the cells that don't have data yet?
|