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
Bookmarks