I am new to Numbers having used Excel for years. I am trying to add up a column of figures but when I highlight the column and click the 'Function' button at the top of the page, all the functions are greyed out so not usable. Can someone tell me what I am doing wrong?
I am using Numbers 3.1, downloaded on Saturday.
Thanks
MacBook Pro, OS X Mavericks (10.9), Still learning how to use a Mac!
drag the quick calculation tags to the destination cell.
The other way to sum a column is to select the destination cell, then type the equal sign ("=sum("), then highlighte the column by clicking the column header, then type ")" and return
drag the quick calculation tags to the destination cell.
The other way to sum a column is to select the destination cell, then type the equal sign ("=sum("), then highlighte the column by clicking the column header, then type ")" and return
Can you add up multiple columns together or do they ahve to be done one at a time?
clarie,
select multiple columns, then drag the quick sum tag or use the formula:
=sum(<RANGE1>, <RANGE2>, <RANGE3>, ...)
where <RANGE1> thru <RANGEn> are any valid ranges
e.g.
=sum(A:C) will sum columns which would be the same thing as:
=sum(A, B, C)
you can also sum rows 1, 4, and 7 like this:
=sum(1:1, 4:4, 7:7)
Thank you :-)
The Function Buttons are Greyed Out in Numbers
