# An Introduction To Using Formulas In Mac Numbers

Learn the basics of using formulas to perform calculations in the Numbers spreadsheet app. You can perform basic arithmetic, copy and paste formulas to multiple rows, and use functions to get the sum of a column.

### Comments: 10 Responses to “An Introduction To Using Formulas In Mac Numbers”

Ric
3 years ago

Thanks for the refresher.

Isabel Ruttle
3 years ago

This came at just the right time for taxes! However, I continue to get '0' as my answer when adding a column. The formula looks right, but, when I press the check mark, the answer is '0'.

I type'=' the formula shows up. I drag the cursor over the column. The cells appear. There are some empty cells in the column. thanks for your help!

3 years ago

Isabel: Start from scratch again and follow along closely with what I am doing in the video. You'll get it.

Isabel Ruttle
3 years ago

Me, again. On a new spreadsheet I followed your directions and it worked!I Unfortunately, when I went back to the original the total was still '0'. So, I opened a new SS and copied the information to it. I still get '0'. Oh, and occasionally, when I hit =, it showed up! Now what?

3 years ago

Isabel: Troubleshoot. Use your deduction skills to figure out what is different. Is there something about the values you are trying to sum up? Maybe they are text instead of numbers. Maybe you have selected the wrong range or there is something included in the range that is not a number. Investigate carefully to find the problem.

Isabel Ruttle
3 years ago

Thanks, Gary Shall do!

Leo
2 years ago

Hey Gary... I have and issue. I need a formula to increase procuct by one for every two people in the household.
1 person gets 1 item, 2 people get 1 item, 3 people get 2 items, 4 people get 2 items, 5 people get 3 items and so on.
I do not know what this type of formula is called and need help.. please can you help me???

2 years ago

Leo: Sounds like you just want simple math. Divide by 2, round up.

Andy
2 years ago

Gary, is there any way to change the default location of the formula edit box after hitting the = key? It appears over the cell being edited, but also over two adjacent cells which I often need to see or select. I realize that the edit box can be moved, but it gets tedious as I frequently have to move this box.

2 years ago

Andy: No, it will always appear right at the cell.