Excel Formula

Question

Hi and thank you for the assistance!

Currently I'm trying to finish building a sheet in excel but that last snag i've run into is that I can't figure out how to setup a cell with a formula to perform addition of another group of cells based on their neighboring cells input. For example lets say I have cells C12, C13, and C14 all with numbers like so: 

C12: $22.00

C13: $57.00

C14: $101.00

But the neighboring cells D12, D13, and D14 have names:

D12: Jerry

D13: Devin

D14: Jerry

How can setup another cell to add the value of C12 - C14 based on whether the cells in column D say Jerry or Devin?

For more clarity I want the formula to basically say "If D* says Jerry then add C*+C*".

I hope that makes sense. 

Thank you for any assistance you can provide!

Answer 1

As others have said, sumif or SumifS is the way to do it via formulas.  If you are new to the world of these formulas, then concentrate on the ones ending in S (the SumifS, AerageIfS formulas).  A limitation of the old Sumif formula was that you could only use a single criteria eg total sales by product.  Sumifs allow for lots of criteria so Total sales by product, by region, by town an by day etc.  A pivot will give you a more dynamic result, coping well if new items appear in the criteria fields but pivots can grow in size on the screen, especially if a criteria has a lot of items in it.

Answer 2

Hi,

You may consider creating a Pivot Table as well.

Answer 3

Hi

Please, try the formula

=SUMIFS($C$2:$C$13,$D$2:$D$13,F2)

Change the ranges in the formula according to your scenario.

I hope this helps you

Regards

Jeovany

Answer 4

Hi brabbit907,

Thank you for reaching out to us. I am Thuy, an Independent Advisor and Microsoft user like you.

For this task, you can apply SUMIF function to get expected result. For instance, with the input as above, you can use the formula as below:

=SUMIF($D12:$D14,"Jerry",$C12:$C14)

You might want to refer to the link below for more information on how to use SUMIF(). If you have more than one criteria, you can use SUMIFS function.

https://support.microsoft.com/en-us/office/sumi...

https://support.microsoft.com/en-us/office/sumi...

Hope this helps!

Regards