Excel formulas

[dtulips]

Hello!

Is there a way to calculate the sum of adjacent cells based on the entered data?

 for example, the cell with the blue text would have the total of 12,000.

Goal achieved:	sum of cells that say yes
amount awarded	towards goal
10,000	yes
2,000	yes
8,000	no

thanks in advance!!

[#2]

@dtulips 

You can use SUMIFS for this:

=SUMIFS(amount_awarded_range, towards_goal_range, "yes")

[#3]

@dtulips In addition to SUMIF you can use SUMPRODUCT as well!

[#4]

Thank you!!