i have a daily total players list, i wanted to make a list and chart, which has number of average players by weekdays (rightside of the picture) in descending order. i used AVERAGE(IF(WEEKDAY($V$4:$V$34)=6;($X$4:$X$34))) and ctrl shift+enter ; but is give a ˝value˝ error, when any cell blank in ($V$4:$V$34);
and i am using 2 small list for get data; the first one, calculate averages by weekdays, second is sorting them with ˝large˝ formula and for to get which day is the best ˝index, match˝ formula...
is it possible in single small list calculate averages(ignores blanks and zeros) and sort them?
(i don´t want to use pivot table)