| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I autosum text?
I need to autosum all cells that have been marked "x"
|
|
#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. "staysee" wrote: I need to autosum all cells that have been marked "x" |
|
#3
|
|||
|
|||
|
Perhaps you mean "count" rather than autosum?
=COUNTIF(A1:A12,"x") Gord Dibben Excel MVP On Mon, 19 Sep 2005 08:04:01 -0700, "Fanatik" wrote: =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. "staysee" wrote: I need to autosum all cells that have been marked "x" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
| Text Wrapping | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| Sort or Filter option? | Excel Worksheet Functions | |||
| Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Linear Mode
