Thread: Average Non-Adjacent Cells in Budget Spreadsheet
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove
 
Posts: n/a
Default Average Non-Adjacent Cells in Budget Spreadsheet
Tim Whitley wrote...
=(F10+H10+J10+L10)/(COUNTA(F10,H10,J10,L10)
....

Why not just use

=AVERAGE(F10,H10,J10,L10)

?

Reply With QuoteReply With Quote