Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Excel formulas

Copper Contributor

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 awardedtowards goal
10,000yes
2,000yes
8,000no

 

thanks in advance!!

3 Replies

@dtulips 

You can use SUMIFS for this:

 

=SUMIFS(amount_awarded_range, towards_goal_range, "yes")

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

 

SanthoshKunder_0-1696302533289.png

 

 

Thank you!!