T
Tracy
This may seem so simple to you guys, but I'm new to
creating functions in Excel. I have a row of "x's" that I
need to be equal to 1 so that if I sum them, I get a
numerical value.
For instance:
Cells A2:A20 needs to be summed. The value is each cell
is "x". I don't know how to create a formula so that Excel
knows "x" is equal to 1 and to add the column, help!
creating functions in Excel. I have a row of "x's" that I
need to be equal to 1 so that if I sum them, I get a
numerical value.
For instance:
Cells A2:A20 needs to be summed. The value is each cell
is "x". I don't know how to create a formula so that Excel
knows "x" is equal to 1 and to add the column, help!