Numbers - Simple formula

Question

Level 1

4 points

Numbers - Simple formula

This is probably very simple task, but I'm not getting it yet.

I have a column (H) representing what I am invoicing. In the end if (H) I'm summarizing all the invoices and this is what I want as well, but now I want another function. On column (M) I wrote Yes when each invoice has been paid. And I want a cell (H1) to look at (M) and if it says (Yes), then add the number from (H) on the same row where it says "yes" in column (M).

So, I want something similar to what my image is showing, however, this one is manually created as you can see. But if column (M) says (Yes) I want each row to add up on the cell on the right to where it says Paid.

I hope it make sense.

Thanks in advance...

Posted on Dec 26, 2019 12:37 AM

Reply

Answer 1

Top-ranking reply

Wayne Contello

Level 7

26,631 points

Dec 26, 2019 6:05 AM in response to Smäck

I suggest that you add a footer row at the bottom of the table, by reducing the size of the table to only those cells you need:

So let's start over and build this from the ground up

Blank, new table:

Open the Table formatter on the right:

Then add to footer rows by selecting "2" from the pop-down menu. I also suggesting making the first row a header row.

Now enter the names of the columns. Now enter your data values:

I'm in a locale that uses the period as the decimal (whereas you are in a locale that uses the comma as the decimal separator). Therefore, I will present formulas with the comma as the delimiter between arguments. you should change these commas to semicolons.

In the footer row (Always the the last two rows of the table because we selected "2"), enter the formula:

=sum(C)

To do this, select cell C19, then type (or copy and paste from here), the formula:

=sum(C)

shorthand for this is:

C19=sum(C)

Now lets add the formula to add up those invoices where you have indicated "Yes"

C20=SUMIF(H, "Yes", C)

you should actually enter the formula (because or currency settings are different):

C20=SUMIF(H; "Yes"; C)

Reply

Answer 2

Smäck Author

Level 1

4 points

Dec 26, 2019 12:40 AM in response to Smäck

I wrote H1 in my question, but in this image H1 is where it says 90 001,0. I didn't want to give you my whole document. But this is what I am looking for.

Reply

Answer 3

Smäck Author

Level 1

4 points

Dec 26, 2019 8:05 AM in response to Smäck

Excellent!! Thank you very much. I was very close in my tries, but didn't nail it. You solved it for me. Appreciated!

Reply