Hi,
I am trying to calculate the median if the values fall between two dates. This is easily achieved with the mean by using an Averageifs formula however I cant figure it out with a median? I have attatched the data I am using, for example how would I find the median for all the data in 2003? Thanks
Last edited by Bigmaq98; 09-07-2023 at 07:21 AM.
Try this,
Please Login or Register to view this content.
Hi, thanks for your response. I have tried that but it calculates the mean, not the median, thanks for your help though
Or try this:
=AVERAGEIFS( A2:A10000,B2:B10000,">="&DATE(2003,1,1),B2:B10000,"<="&DATE(2003,12,31))
Hi, thanks for your help but that also calculates the mean not the median
Try again:
=MEDIAN(IF(YEAR(B2:B10000)=2003,A2:A10000))
Enter with Ctrl+Shift +Enter.
Amazing!!! Thank you so much that worked! This is my first ever post on this forum, so glad I signed up
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks