View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Calculating over Multiple Columns

I have a spreadsheet as follows

A B C
1 10 78 46
2 27 46 32
3 45 99 86

Is it possible to highlight all the cells and then divide by 3.3.

Currently I put a formula in D,E,F and then drag down. Can I avoid this last
step and just highlight A,B.C and do some magic?