No need to answer I have the formula, thanks!
{=IF(ISERR(MEDIAN(IF($F$5:$F$17=4,$H$5:$H$17))),"No Minutes Done for This
Unit",MEDIAN(IF($F$5:$F$17=4,$H$5:$H$17)))}
On Thu, Mar 24, 2011 at 9:01 AM, Anderson, Susan <susan.ander...@vmmc.org>wrote:
> Hi ,
>
> Can you help me with the formula below? See Tab Mar 05, column AB or AC
>
>
>
> It works fine for finding the median number but if it cannot find the
> criteria then it answers with #NUM error. Do you know how I can rewrite the
> formula to replace the #NUM with “No Minutes Done for This Unit”
>
>
>
> {=MEDIAN(IF($F$5:$F$17=4,$H$5:$H$17))}
>
>
>
> Thanks for your help!
>
>
>
>
>
>
>
> Susan Anderson
>
> Admin Assistant II l Clinical Administration H4-483
>
> Office: 206-341-0183 l Fax: 206-341-0638 l Pager: 206-541-0588
>
>
>
>
>
>
>
>
>
> *From:* Susan [mailto:sunni...@gmail.com]
> *Sent:* Thursday, March 24, 2011 6:55
> *To:* Anderson, Susan
> *Subject:* FW: $$Excel-Macros$$ Median If Formula
>
>
>
>
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Dave Bonallack
> *Sent:* Thursday, March 24, 2011 2:00 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Median If Formula
>
>
>
> Hi Susan,
> =MEDIAN(IF(F5:F17=1,H5:H17))
> This is right, but it's an array formula, so you have to enter it with
> Ctrl+Shift+Enter
> When you do this, it gives the right answer.
> Regards - Dave.
>
> ------------------------------
>
> Date: Wed, 23 Mar 2011 14:39:36 -0700
> Subject: $$Excel-Macros$$ Median If Formula
> From: sunni...@gmail.com
> To: excel-macros@googlegroups.com
>
> Hi,
>
>
>
> See tab named Mar 05 in the attachment.
>
>
>
> I'm trying to get Excel 2007 to calculate the Median in data Columns H ,
> cells 5 through 17, but only if it meets certain criteria of Task done in
> Column F, cells 5 to 17.
>
>
>
> My formula which should work, is =MEDIAN(IF(F5:F17=1,H5:H17)), but the
> answer is wrong , 40
>
>
>
> but when I did a manual median formula =MEDIAN(H5,H9,H17) , of those cells
> in Column F that meet the criteria of "1", the answer is 55
>
>
>
> When I place in "" around =1 the formula doesn't work at all. By removing
> the "" makes the formula work but it's not calcuating the median correctly.
>
>
>
> Any help with this would be excellent!
>
>
>
> ~Susan
>
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> ****************** CONFIDENTIALITY DISCLAIMER ******************
>
> The information contained in this e-mail may be confidential. IF YOU
> RECEIVED THIS IN ERROR, please call the Virginia Mason Privacy Officer
> through the Virginia Mason Operator at (206) 223-6600. Thank you.
>
> Patients: E-mail is NOT considered secure. By choosing to communicate
> with Virginia Mason by e-mail, you will assume the risk of a confidentiality
> breach. Please do not rely on e-mail communication if you or a family
> member is injured or is experiencing a sudden change in health status.
>
> If you need emergency attention, call 911.
>
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
