View Single Post
  #2   Report Post  
Old September 24th 13, 09:16 PM posted to microsoft.public.excel.newusers
Claus Busch Claus Busch is offline
external usenet poster
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,669
Default The sum of the same function that is used for a range of cells

Hi Joris,

Am Tue, 24 Sep 2013 17:39:02 +0100 schrieb Drakendodertje:


This works. But like the SUM(C4:C9) formula, i would prefer to bring
this formula down to a range instead of inserting the function for each
cell seperately.

and enter the arrayy formula with CTRL+Shift+Enter

Claus B.
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2