Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel Formula
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel Formula
Resolved · High Priority · Version 2010
Reply Fri 9 Sep 2011, 14:12Delegate Megan said...
Megan has attended:
Excel Advanced course
Excel Formula
Hi there,
I have the below formula
=IFERROR(MEDIAN(IF(Works!$B$1:$B$6568=DS7,IF(Works!$Z$1:$Z$6568>0,Works!$Z$1:$Z$6568))),0)
that I simply copied from a report that I do each month, the only difference this month is I have added an extra column I have changed the formula to ensure it still picks up the correct cell reference but for some reason it does not work.
When I look into the previous month's formula it shows the curly brackets {} around the formula, but if I F2 then they aren't there, so the formula looks like:
{=IFERROR(MEDIAN(IF(Works!$B$1:$B$5036=DS4,IF(Works!$Y$1:$Y$5036>0,Works!$Y$1:$Y$5036))),0)}
I'm not sure why it doesn't work this month, I am wondering if it is to do with a formatiing of the sheet where the data comes from or something wrong with my formula.
Any help from anyone would be amazing.
Thankyou very much.
For upcoming training course dates see: Pricing & availability
Reply Fri 9 Sep 2011, 14:50Delegate Megan said...
RE: Excel Formula
Figured it out- array formulas, press CNTRL+SHIFT+ENTER! Doh!
|