AVERGEIFS and OR formula

[CookieMonster76]

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 result if it is either "Surrendered" or "Current"?

Thanks

pPaul

 

[Rajneesh Rawat]

Hi,

Hope this help:

=OR(logical1, logical2)

 

[RoryA]

You could use:

=SUM(SUMIFS('Sales History'!T:T,'Sales History'!B:B,A8,'Sales History'!C:C,{"Surrendered","Current"}))/SUM(COUNTIFS('Sales History'!T:T,'Sales History'!B:B,A8,'Sales History'!C:C,{"Surrendered","Current"}))