Sum of numbers if column equals

[bitluxkyle]

Hi there,

Me again - please see attached.

Under sheet "Sponsor List/Income"

H14 should equal whatever the total income is for all rows with T1 in column B.

There are two - APR and Forge Motorsport, so the total should be, $7,500.

H15 will be for T2

H16 will be for T3

End goal, to find the total income for each tier of sponsor (T1, T2, or T3)

Thank you SO MUCH!!

[FDibbins]

Try this, copied down...
=SUMIF($B$3:$B$17,"T"&MID(G14,6,1),$C$3:$C$17)

[BadlySpelledBuoy]

Or this in H14:

Please Login or Register  to view this content.

And adjust T1 to T2 and T3 for H15 and H16 respectively.

BSB

[bitluxkyle]

Try this, copied down...
=SUMIF($B$3:$B$17,"T"&MID(G14,6,1),$C$3:$C$17)

Works!

Is there a place where I can go to learn this stuff? The value of this just today has been incredible. Saves me about 50 columns

[bitluxkyle]

Or this in H14:

Please Login or Register  to view this content.

And adjust T1 to T2 and T3 for H15 and H16 respectively.

BSB

Got it - could you briefly explain how exactly that works?

SUMIF (produce a number if the range of cells), (is equal to "xxx"), (sum of range)

correct?

[BadlySpelledBuoy]

Pretty much. Sum all values in column C where the corresponding row shows T1 in column B.

BSB

[FDibbins]

Im happy to help

Works!

Is there a place where I can go to learn this stuff?....

Yup, right here
I am self-taught (as are many others), but most of what I know, came from here - seeing how others approach questions, trying to understand what they did, trying to answer questions myself. Pretty much practice.

Also, the formula edit bar (click the FX button on a cell containing a formula), and above all, dont be afraid to experiment!! You cant really do any damage if you dont save the file.