I am sure the answer to this is already out there somwhere...
if I use average formula:
=AVERAGEIF('Customer Experience 16-17'!$B$2:$KB$22,"CAT",'Customer Experience 16-17'!$C$2:$K$22)
I get a result
however if i try and add another criteria using AVERAGEIFS
=AVERAGEIFS('Customer Experience 16-17'!$C$2:$KB$22,'Customer Experience 16-17'!$B$2:$B$22,"CAT",'Customer Experience 16-17'!$O$2:$O$22,"DOG")I get a VALUE error,
there has to be a way around this????
Bookmarks