max,min,average

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

im tring to use these formulas 52 cells horizontally examples
g5,k5,o5,s5,w5,aa5 etc can i please get some help or an example
 
Please note that this is an array formula. You create array formulas in the
same way that you create other formulas, except you press CTRL+SHIFT+ENTER to
enter the formula. If successful in 'Formula Bar' you can notice the curly
braces at both ends like "{=<formula>}"

=MIN(IF((MOD(COLUMN(G5:AA5),4)=3)*(ISNUMBER(G5:AA5)),G5:AA5))
=MAX(IF((MOD(COLUMN(G5:AA5),4)=3)*(ISNUMBER(G5:AA5)),G5:AA5))
=AVERAGE(IF((MOD(COLUMN(G5:AA5),4)=3)*(ISNUMBER(G5:AA5)),G5:AA5))


If this post helps click Yes
 
Back
Top