I'm looking to find the average total of column D if A, B, C columns match criteria.
I would have the criteria in one sheet and it would be looking at a:a, b:b, c:c, d:d of another sheet.
For example if a="bob" and b=jones" and c="bill" then what is the average of d for all instances.Excelforum_match3_average.xlsx
Small example is attached.
Thanks for your help!
Rob
Bookmarks