Hi

I have the following formula but I need to amend it with an OR. I would like the formula average totals if P = "T" and V = "T" but they don't both have to be "T". I have tried a couple of variations now but don't seem to be able to get the correct average??

=AVERAGE(IF(ISNUMBER('Before Oct13'!$AE$2:$AE$78),IF('Before Oct13'!$P$2:$P$78="T",IF('Before Oct13'!$V$2:$V$78="T",'Before Oct13'!$AE$2:$AE$78))))

Please help!
Many thanks
Mack_76