I need to autosum all cells that have been marked "x"
F Fanatik Sep 19, 2005 #2 =SUMIF(B:B,"X",A:A) Assuming that column B contains all the Xs and column A contains the values you want to sum. Note instead of defining columns you can also define ranges.
=SUMIF(B:B,"X",A:A) Assuming that column B contains all the Xs and column A contains the values you want to sum. Note instead of defining columns you can also define ranges.
G Gord Dibben Sep 20, 2005 #3 Perhaps you mean "count" rather than autosum? =COUNTIF(A1:A12,"x") Gord Dibben Excel MVP
