Average Every Second Column
One way
=AVERAGE(IF(MOD(COLUMN(C8:AJ8),2)=1,IF(C8:AJ8<"", C8:AJ8)))
entered with ctrl + shift & enter
--
Regards,
Peo Sjoblom
"Killer" wrote in message
...
I was wondering if it's possible to get an average from every second column
listed below?
C8, E8, G8, I8, K8 M8, O8, Q8, R8, T8, V8, X8, Z8, AB8, AD8, AF8, AH8, AJ8
Thanks
|