Excel formula error

Pete. · Super Spammer Joined: 22 Aug 2006 Karma :

Just a quickie but I'm an excel noob.

I want to use this formula:

AVERAGEIF(F10:F16,J5 "<>0")

but when I add the J5 it gives me an error. How can I prevent this?
____________________
a.k.a 'Geri'

132.9mph off and walked away. Gear is good, gear is good, gear is very very good Very Happy

Paivi · World Chat Champion Joined: 30 Sep 2005 Karma :

What are you trying to do?

If you get stuck, there's an excellent website for all kinds of questions, even really complex formula based ones:

https://www.mrexcel.com/forum/index.php
____________________
My other bike's a Monster... Wink

Frost · World Chat Champion Joined: 26 May 2004 Karma :

https://spreadsheets.about.com/od/excel2010functions/qt/100114-excel-2010-averageif-function.htm

Neverseen AverageIf before, but then i've not used excel for a long time.

Slacker24seve... · World Chat Champion Joined: 10 May 2010 Karma :

My beer addled brain can't compute at the moment but if you've not solved it by tomorrow I'll have a look at work. More familiar with COUNTIF, SUMIF, WHATIF and pretty much every other IF though!
____________________
Triumph Daytona 675 track bike + girlfriend's Honda Hornet 600
Selling a hack/winter bike for less than a grand? PM me.
Banger rallies are ace

Pete. · Super Spammer Joined: 22 Aug 2006 Karma :

Thanks for the replies - I got around it by working another way. I was using averageif to ignore cells with '0' in them, but the problem I actually had was I wanted to calculate the average value of a number of cells, some were in a contiguous row (so I put in the range) and one other single cell. It didn't like the single cell I put in.
____________________
a.k.a 'Geri'

132.9mph off and walked away. Gear is good, gear is good, gear is very very good Very Happy