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 yesamount awardedtowards goal10,000yes2,000yes8,000no thanks in advance!!

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!

Forum Discussion

Copper Contributor

Oct 02, 2023

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.

thanks in advance!!

SanthoshKunder
Iron Contributor
Oct 03, 2023
dtulips In addition to SUMIF you can use SUMPRODUCT as well!
HansVogelaar
MVP
Oct 02, 2023
dtulips

You can use SUMIFS for this:

=SUMIFS(amount_awarded_range, towards_goal_range, "yes")
- dtulips
  Copper Contributor
  Oct 04, 2023
  Thank you!!