| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 50709 | 2004-10-29 19:28:00 | Microsoft Excel - Help with | JohnHardy (6332) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 286052 | 2004-10-29 19:28:00 | I am using Microsoft Excel. How or what formula/function do I use to gain the sum of the entire contents of a column, regardless of how many rows or which rows within the column, contain data? I want to input and display this calculation in cell H10. The range I want the sum of, is column E. All of it. I could limit the range from cell E1 to some distant and unlikely used upper row limit; example =SUM(E1:E2million). Although row two million will not be exceeded, it is still a potential limit and it seems an inefficient method of achieving this sum. Surely there is a better method. Surely? | JohnHardy (6332) | ||
| 286053 | 2004-10-29 19:49:00 | A good place for excel problems is here (216.92.17.166) Thats if no one helps . hth |
johnboy (217) | ||
| 286054 | 2004-10-29 20:37:00 | =SUM(A:A) | Greg S (201) | ||
| 286055 | 2004-10-29 20:38:00 | > =SUM(A:A) Sorry, in your case it's =SUM(E:E) which you put into your H cell. |
Greg S (201) | ||
| 286056 | 2004-10-29 21:38:00 | Simple, easy - worked fine. Thank you Greg S!!! | JohnHardy (6332) | ||
| 286057 | 2004-10-29 23:11:00 | > H10. The range I want the sum of, is column E. All of > it. I could limit the range from cell E1 to some > distant and unlikely used upper row limit; example > =SUM(E1:E2million). Although row two million will not > be exceeded, it is still a potential limit and it > seems an inefficient method of achieving this sum. Of course E65536 would not be exceeded either, as that is the row limit ;) You might possibly run into problems using Greg's solution if you have text in any of the cells. Mike. |
Mike (15) | ||
| 286058 | 2004-10-29 23:53:00 | > You might possibly run into problems using Greg's > solution if you have text in any of the cells. Yeah just checked that (in Excel 2003) and it does muck things up. Fortunately there's a fix, by clicking on the error indicator and disable/ignore the appropriate cell contents type. Not sure if that's the long way round, but can't find another right now. |
Greg S (201) | ||
| 286059 | 2004-10-30 00:21:00 | > > You might possibly run into problems using Greg's > > solution if you have text in any of the cells. > > Yeah just checked that (in Excel 2003) and it does > muck things up. I've just rechecked, and I made a typo in my formula - in 2003 text doesn't actually affect it after all :8} |
Greg S (201) | ||
| 1 | |||||