Sum of numbers from a table

[redclay]

Hi, really looking for some help on what I think will be an easy formula for this forum.

I'm looking to sum a series of numbers that are tied to a specific tranche number.

What is sum of numbers in Column B if A8:19 = 1 and so forth. Thank you so much.

 

[redclay]

Sorry here is the screenshot

 

[p45cal]

=SUMIF($A$8:$A$19,A2,$B$8:$B$19)

copy down.

 

[redclay]

That's it. Thank you so much!

 

[pecoflyer]

In the future please post a sheet, not an image. Thx

 

[redclay]

Hi pecoflyer, wanted to follow back up and say thank you again for your help. I'm still getting familiar with certain formulas so this is very helpful for me.

I am also trying to solve for the attached formula. Would love your thoughts on it.

I'm raising capital for this phased condo/hotel development in North Carolina and I need the seller to roll into the deal in a pref equity position.

Thank you.

Brad

 

[vletm]

redclay​

Do Your other posting have something common with above file?

Excel Formula Help

Hi, would really appreciate help on a formula in the attached spreadsheet. I've been running a makeshift formula so everytime the assumptions change I have to go in manually and update this formula. Your help is very appeciated! Brad

chandoo.org

 

[redclay]

redclay​

Do Your other posting have something common with above file?

Excel Formula Help

Hi, would really appreciate help on a formula in the attached spreadsheet. I've been running a makeshift formula so everytime the assumptions change I have to go in manually and update this formula. Your help is very appeciated! Brad

chandoo.org

Hi, yes same as what was posted in the forum. Thanks.