Hi All,
I'm familiar with SumIf and CountIf but not AverageIf, so wondering if this is going to work for what I need?
I have 2 columns.
Column 1 - Order No.s (these may appear more than once if orders get split but the original order number remains)
Column 2 - Sales Value
I want to be able...