G Guest Mar 3, 2007 #1 this is an expense report for 2006.There are 10 to 50 figures in a given column ie. A that I need a sum of the total column
this is an expense report for 2006.There are 10 to 50 figures in a given column ie. A that I need a sum of the total column
K KL Mar 3, 2007 #2 =SUM(A5:A50) ??? -- KL [MVP - Microsoft Excel] RU: http://www.mvps.ru/Program/Default.aspx ES: http://mvp.support.microsoft.com/?LN=es-es EN: http://mvp.support.microsoft.com/?LN=en-us Profile: https://mvp.support.microsoft.com/profile=AB32F8EE-8ED3-4AB9-ADDA-9E6C73C09A36
=SUM(A5:A50) ??? -- KL [MVP - Microsoft Excel] RU: http://www.mvps.ru/Program/Default.aspx ES: http://mvp.support.microsoft.com/?LN=es-es EN: http://mvp.support.microsoft.com/?LN=en-us Profile: https://mvp.support.microsoft.com/profile=AB32F8EE-8ED3-4AB9-ADDA-9E6C73C09A36
B Bob Phillips Mar 3, 2007 #3 =SUM(A:A) -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)