Hi,
I have been given an excel 2007 model but I only have Excel 2003 on my work computer. When I have opened up the model, I got #name in the cells where there is this formula. After doing somer research I learned that AVERAGE(IF( should be used; some say as an array formula, other's don't. I was wondering how to do it for this AVERAGEIF formula:
Thanks so much for the help=AVERAGEIF(G365:CJ365,">"&0,G365:CJ365)
Last edited by MrSumitomo; 07-15-2011 at 09:20 AM.
=AVERAGE(IF(G365:CJ365>0,G365:CJ365))
Confirmed with Ctrl+Shift+Enter as it's an array formula.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Or the normal formula:
=SUMIF(G365:CJ365,">0")/COUNTIF(G365:CJ365,">0")
Fantastic! They both worked, thanks so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks