Hi attached exmaple spread sheet..
I want the Average figures from b2-m2 in cell n2...
Iv looked on here and tried =AVERAGE(IF(ISNUMBER(U8:AF8),U8:AF8))
but I dont get it, can anyone please help
Hi attached exmaple spread sheet..
I want the Average figures from b2-m2 in cell n2...
Iv looked on here and tried =AVERAGE(IF(ISNUMBER(U8:AF8),U8:AF8))
but I dont get it, can anyone please help
Your formula needs to be =AVERAGE(IF(ISNUMBER(B2:M2),B2:M2)). It was missing the second B2:M2. Also, it needs to be confirmed with Ctrl+Shift+Enter and not just Enter.
Hi I have added the correct details..
when I Ctrl+Shift+Enter it just confirms the code in cell N2...
Am I doing something wrong?
When you do this, is your cursor in the formula bar when you hit this combo? If so, you should see curly brackets {} around the entire formula. Clicking anywhere in the formula bar afterward will remove these brackets and necessitate reconfirming the formula.when I Ctrl+Shift+Enter it just confirms the code in cell N2...
Thats got it, must have moved the cursor...
Can I ask the reason why for the Ctrl+shift and enter rather than enter what does this do?
Just so I dont have to keep bothering people.
It's used to enter the formula as an array formula. Array formulas are used when you have a function that normally applies to only one cell (in this case, Isnumber) that you want to apply to a range of cells. It forces the formula to take each case individually according to the functions and convert them to TRUE/FALSE or values as appropriate.
I'm not really sure why Microsoft deemed it necessary to add this step, but oh well...That's the way it is.
Thanks for the help and explaining....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks