| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting help
Thanks to the both of you for helping.
"Bob Davison" wrote: "Boenerge" wrote in message ... Thanks Bob, I have tried the formula and it doesn't return any results, is it possible to make it add the numbers in the cells and return the figure. The array of cells I am talking about is cells covering a whole spreadsheet. The cells will contain both numbers and text, it is the numbers I am interested in. Biff's (T. Valko) idea is much better than mine. You can use his formula to strip out all the numbers, one cell at a time and then add them up. I don't know how to do it all at once with one formula. The formula I came up with does work but I had a problem copying it from my reply. In order to get it to work, it must be inserted as one continuous line of code, not individual lines. I had to "reconnect" the code using one backspace at each break. A little tricky but then it works fine. Bob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help Counting | Excel Discussion (Misc queries) | |||
| Help Counting | Excel Discussion (Misc queries) | |||
| Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
| Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
| Counting... | Excel Worksheet Functions | |||
Hybrid Mode
