You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I wish to total a column but only include some of the values in that column based on the content of an adjacent column.
In the example below, I only wish to total George's lollies.
The thing is, I need the total to change if the names change.
Also, should it be relevant, the Child column is a column of formulae itself, not text.
iMac 24″, macOS 12.6
SUMIF and SUMIFS are your friend here. You can find out more about them and other functions at Help > Formulas and Functions Help in your menu.
You can try something like this:
In B9:
=SUMIF(A,A$9,B)
Note that row 9 is defined as a Footer Row so you can have a formula in the same column that refers to all the body cells above it.
The total will change when you add rows, or change the name in A9.
(Substitute ; for , in the formula if your region uses , as a decimal separator.)
SG
SUMIF and SUMIFS are your friend here. You can find out more about them and other functions at Help > Formulas and Functions Help in your menu.
You can try something like this:
In B9:
=SUMIF(A,A$9,B)
Note that row 9 is defined as a Footer Row so you can have a formula in the same column that refers to all the body cells above it.
The total will change when you add rows, or change the name in A9.
(Substitute ; for , in the formula if your region uses , as a decimal separator.)
SG
Got that. Many thanks.
How to total parts a column
