I have a data set 1557 rows by 26 columns. I am looking to get the mean and median values of column x for all associated values when column s is greater than 360. Any ideas?
I have a data set 1557 rows by 26 columns. I am looking to get the mean and median values of column x for all associated values when column s is greater than 360. Any ideas?
Last edited by Cubsfan1; 02-20-2007 at 03:14 PM.
=median(if(s1:s1500>360,x1:x1500))
an array formula so instead of enter use control+shift+enter
similar for average function
not a professional, just trying to assist.....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks