Additional IF Statement - Help!

[mack_76]

Hi

I am trying to add another IF statement into my formula and it isn't working. I currrently have

=AVERAGE(IF(ISNUMBER('Before Oct13'!$AS$2:$AS$78),IF('Before Oct13'!$L$2:$L$78="Fratton",'Before Oct13'!$AS$2:$AS$78)))

but I want to add in another condition. I have tried the following but it doesn't give me the current answer

=AVERAGE(IF(ISNUMBER('Before Oct13'!$AS$2:$AS$78),IF('Before Oct13'!$K$2:$K$78="4",'Before Oct13'!$L$2:$L$78="Fratton",'Before Oct13'!$AS$2:$AS$78)))

My answer should be 1.26 but I am getting 1.12 ???

Data is also attached for reference, any help will be appreciated.

Thanks
Mack

[Pete_UK]

Try it like this:

=AVERAGE(IF(ISNUMBER('Before Oct13'!$AS$2:$AS$78),IF(('Before Oct13'!$K$2:$K$78="4")*('Before Oct13'!$L$2:$L$78="Fratton"),'Before Oct13'!$AS$2:$AS$78)))

Commit using Ctrl-Shift-Enter.

Hope this helps.

Pete

[mack_76]

Hi

I have tried this but I now get #DIV/0! ??

[Pepe Le Mokko]

Try it like this:

=AVERAGE(IF(ISNUMBER('Before Oct13'!$AS$2:$AS$78),IF(('Before Oct13'!$K$2:$K$78="4")*('Before Oct13'!$L$2:$L$78="Fratton"),'Before Oct13'!$AS$2:$AS$78)))

Commit using Ctrl-Shift-Enter.

Hope this helps.

Pete

Slight typo by Pete. Just replace "4" with 4 ( double quotes make it a text string). Works perfectly

[mack_76]

Thank You - it's working...