Hi
I have the following to return 2 seperate numbers:
=AVERAGEIFS('Sales History'!T:T,'Sales History'!B:B,A8,'Sales History'!C:C,"Surrendered")
=AVERAGEIFS('Sales History'!T:T,'Sales History'!B:B,A8,'Sales History'!C:C,"Current")
How do I get an OR statement into it so it brings back a...