So, I'm trying to automate all the dollar amount fields in the blue table on the right (with titles: group, type, and month), based on the table to the left.
All rows from the table at the left, under the Group: Advocacy (for example), the dollar amounts from the Cost column in that corresponding row (and all others with Advocacy under Group) should add together into the Advocacy row in the blue table at the right. And so on for each Group (Community, Wedding, Safety, etc.). I'd like to have the same type of thing happen if the cost is associated with Donation/Marketing/Sponsorship in the Type column, and Month, based on Ring Date column.
I'm very new to if/then statements so could use help. Everything I've found so far are resources to output simple text, but I need to carry over the cost of all rows associated with that group, type, or date into one field.
Edit: Uploaded a document to manipulate, the current 'desired outcome' is in the cells, just manually added the cost values based on group category.
Excel If Then Question.JPG
Bookmarks