Counting using 9-key pad

T

tarakd37

Is there a formula or function that will allow you to count within a cell?
For instance, I'm going through a spreadsheet and am wanting to be able to
count this data while in excell. Is there any way to have the keystrokes
counted and continue to count? If I press the 1 then the 2 then the 5 have
the cell sount these and make the value 8?
 
S

ScottO

If you're trying to count or add cell values which match some specific criteria, then you could use
the CountIf or SumIf function - refer to in-built help for syntax.
Rgds,
ScottO

| Is there a formula or function that will allow you to count within a cell?
| For instance, I'm going through a spreadsheet and am wanting to be able to
| count this data while in excell. Is there any way to have the keystrokes
| counted and continue to count? If I press the 1 then the 2 then the 5 have
| the cell sount these and make the value 8?
|
 
S

Sandy Mann

If the values are in cells then try holding down the control key while you
click into the cells to produce a sum of the selected cells in the task bar.

--
HTH

Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk
 
Top