dtulipsCopper ContributorOct 02, 2023Excel formulas 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 ce...Show More
HansVogelaarMVPOct 02, 2023dtulips You can use SUMIFS for this: =SUMIFS(amount_awarded_range, towards_goal_range, "yes")
