I would like a create a sum of values in one column that meets the criteria of matching the selected list item of another column that is in another table.
Is this possible?
ie: I have an large entry table that includes all travel entries for a travel agency. One column is called “fee” and there are different entries for different travel packs sold, hence different fees. I have another table that aims at summarizing the outcome of every travel pack and I’d like to show one column to present to “total fee” received from every travel pack.
Hi! Can you share what formula you used to do this? I feel like I’ve tried every variation of this that I can think of with no luck.
Basically I am trying to add together the values of one column based off of the status of another. For example:
I have a column where the status’s are “Open” and “Closed”.
I have another column with Subtotals.
I want to see how much money I have in “open” status, and how much I have in “closed” status.
Sounds simple to me but I can’t find a formula that works! I am very new though so maybe that’s why.