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

Add a column of answers from If formulas

So I have a Numbers spreadsheet, and one of the columns has drop downs. These use If formulas to populate a number in another column. I want to add that entire column, but it's not adding, nothing is happening. It's like it's not recognizing it as having any values at all. What am I missing?

MacBook Air 13″, macOS 12.0

Posted on Jan 10, 2022 4:31 PM

Reply
Question marked as Best answer

So I've used this simple spreadsheet to calculate how much bonus for my employees, and in the past, they've entered 1 or 1.5 themselves in column G. Except I thought I'd make it even easier and as they selected the drop-down of 60 or 90 in column C, it would auto-populate in the column G at either 1 or 1.5 hrs for them, eliminating one more thing they have to do (and less human error for me to correct). Then, at the bottom, total the amount of massage hours in a pay period, and multiply that by their massage hour pay rate, and I get how much to pay them in bonus per pay period. Except after I added the drop down menu formula, it's no longer adding up column G. It's as if there isn't any numbers in column G. I think this is what you were explaining earlier. Cell G8 is: SUM(G2:G7). This is only 1 day's worth, at the end of a pay period, it's 2 pages long, so it really would be easier to auto sum them all. What I think you're saying is that the formula I have in column G should be in a blank column and hidden, and then column G should have a formula that references that and turns it in to a number value instead of words? The biggest problem is I don't know the language to use to ask the correct questions in the youtube searches and therefore haven't been able to come up with what I want to do. TIA!

Posted on Jan 10, 2022 11:41 PM

4 replies

Jan 10, 2022 4:59 PM in response to anpm2514

Welcome, anpm2514, to Apple Support Communities!


Are you trying to add the entire Column that is calculated using the “If” formulas?


Or are you trying to add the entire Column where the Cell values are determined from ”drop downs”?


I have used calculations (such as SUMs and COUNTs) on Columns calculated using SUMIF[S] and similar.


I have also used similar calculations on Columns calculated using IFS (and the more normal IF) functions.


So, It may help to provide further details about what you are actually trying to accomplish.

Question marked as Helpful

Jan 10, 2022 10:19 PM in response to anpm2514

This may bear some resemblance to your table.


one of the columns has drop downs.

     (in Numbers, these are "popup menu cells")


These use If formulas to populate a number in another column.

     (actually, the formulas uses the values in these cells to determine a value and enter it   

       into the cell containing the formula.)


I want to add that entire column, but it's not adding, nothing is happening.

It's like it's not recognizing it as having any values at all. What am I missing?

   (Insufficient information.

What have you done to tell Numbers to sum that column?

    If your answer is 'nothing'. that would explain the lack of action from Numbers.

    If your answer is anything other than 'nothing', then sharing your description of what

    you have done would likely provide a hint to the answer to "What am I missing?"


While waiting for your information, you might take a look at this example.


The formula does not use IF, but other than that, it does what I think you are trying to do.



Values in column C are determined by user choice from a popup menu in each of the cells, containing a list of the values "none" (which displays as a blank cell) and "Item 1" through "Item 9".

The formula shown below the table is entered in cell E2, then filled down to cell E10. Inthe formula, RIGHT(cell) gets the value (a text string) from the referenced cell and returns the last character in that text (a digit from 1 to 9) to VALUE. The VALUE function accepts that text value and converts it to a number, which is then multiplied by 100. The result is placed in the cell containing that copy of the formula.


Row 11 has been converted to a Footer Row.


The formula in E11 is SUM(E)


The formula returns the sum of the numbers in all non-header and non-footer cells in column E of the table.




A screen shot of your table and copies of the formula(s) you are using would help refine the notes above.


Regards,

Barry


Question marked as Best answer

Jan 10, 2022 11:41 PM in response to anpm2514

So I've used this simple spreadsheet to calculate how much bonus for my employees, and in the past, they've entered 1 or 1.5 themselves in column G. Except I thought I'd make it even easier and as they selected the drop-down of 60 or 90 in column C, it would auto-populate in the column G at either 1 or 1.5 hrs for them, eliminating one more thing they have to do (and less human error for me to correct). Then, at the bottom, total the amount of massage hours in a pay period, and multiply that by their massage hour pay rate, and I get how much to pay them in bonus per pay period. Except after I added the drop down menu formula, it's no longer adding up column G. It's as if there isn't any numbers in column G. I think this is what you were explaining earlier. Cell G8 is: SUM(G2:G7). This is only 1 day's worth, at the end of a pay period, it's 2 pages long, so it really would be easier to auto sum them all. What I think you're saying is that the formula I have in column G should be in a blank column and hidden, and then column G should have a formula that references that and turns it in to a number value instead of words? The biggest problem is I don't know the language to use to ask the correct questions in the youtube searches and therefore haven't been able to come up with what I want to do. TIA!

Add a column of answers from If formulas

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.