Hi, I need some help figuring out some formulas.
So I'm trying to set up some tables showing cost vs revenue of some marketing data. I'm setting up my tables on the first sheet and the data that I'm pulling from on the second. The data is organized by what source our clients came from, how much that source cost us and how much revenue the client contract generated.
For my data I need to set up formulas that shows the average cost of each market, the total cost of each market, the average contract value and total contract value. Any idea on what formulas could work or any links to tutorials? It'd be much appreciated.
Bookmarks