Hi - Dave here.
Happy Friday!
I ran into an interesting "average if" problem last week...
How can we calculate the average for each group as seen below?
[
download the workbook and read the full explanation]
I was inspired to create this example after watching a video by Excel expert Chandoo on the same topic. The article above walks through four different approaches and explains why AVERAGEIFS won't work in this case. Download the workbook and try it out yourself.
Excel formulas
To be good with Excel formulas, you must practice!
We maintain a large list of working formulas
here.
If you need more structure, we also offer
video training.
Have a fun and safe weekend!
Dave
