Computing and Displaying Averages from One Column Based on Criteria in a Different Column
I'm working on a salary negotiation tracker in which I am trying to display average negotiation amounts across several department. I have the dollar amount in one column and department in another. I know AVERAGEIF can work across columns, but I've tried a few different ways of writing the computation, and I don't think it was designed to work in quite this setup.
Attached is a sample mockup of my sheet. Ideally, I would like to write something that grabs the value from the Dept Column and then averages the values in the Negotiation Amount column for those rows.
