Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Question:

Question: Numbers: how can I gather various numbers referred to same item (such as same kind of cost in a balance sheet)?

How can I get the sum of various figures of a large spread sheet referred to the same cost center ?

iPad 2, iOS 6.0.2

Posted on

Reply
Question marked as Solved
Answer:
Answer:

Hi Mauzanna,


Take a look at SUMIF and SUMIFS in the function browser.


To open the browser, click on any (empty) cell, then type =


The Function Browser will open in the right sidebar.


Click on the search box at the top of the browser pane and type sum


As you type, a changing list will appear in the space below the search box.


Click on SUMIF when it appears, and you'll get a description plus at least one example showing how that function might be used in a spreadsheet.


Double clicking the function name in the list will insert the function (and its prompts) into the Formula Editor, also opened when you typed = above.


Regards,

Barry

Posted on

Page content loaded

Question marked as Solved

Mar 12, 2018 5:17 AM in response to Mauzanna In response to Mauzanna

Hi Mauzanna,


Take a look at SUMIF and SUMIFS in the function browser.


To open the browser, click on any (empty) cell, then type =


The Function Browser will open in the right sidebar.


Click on the search box at the top of the browser pane and type sum


As you type, a changing list will appear in the space below the search box.


Click on SUMIF when it appears, and you'll get a description plus at least one example showing how that function might be used in a spreadsheet.


Double clicking the function name in the list will insert the function (and its prompts) into the Formula Editor, also opened when you typed = above.


Regards,

Barry

Mar 12, 2018 5:17 AM

Reply Helpful (1)
User profile for user: Mauzanna

Question: Numbers: how can I gather various numbers referred to same item (such as same kind of cost in a balance sheet)?