Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
#2
![]() |
|||
|
|||
![]()
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 "tarakd37" wrote in message ... | 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? | |
#3
![]() |
|||
|
|||
![]()
You might want to look at this
http://www.mcgimpsey.com/excel/accumulator.html -- Regards, Peo Sjoblom (No private emails please) "tarakd37" wrote in message ... 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? |
#4
![]() |
|||
|
|||
![]()
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 Replace@mailinator with @tiscali.co.uk "tarakd37" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
Counting Unique Records with multiple conditions | Excel Worksheet Functions | |||
Counting... | Excel Worksheet Functions | |||
counting Multiple answers in 1 cell + column | Excel Discussion (Misc queries) |