Thread: Sum of values
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Sum of values

When you finish typing in the formula then hit Ctrl+Shift+Enter (not just
enter as you normally would). This makes the formula into an array formula.
You will know if you did it right because in the formula bar the formula will
have curly braces { } around it.
--
HTH...

Jim Thomlinson


"jk" wrote:

Two for sure dumb questions, why have a column "D" if coulmn "A" is for
accounts,column "B" is for corresponding dollar amounts and column "C" is for
the results of sumed account values? Do you hit cntrl shift enter first on a
cell then enter the formula?

"Bob Phillips" wrote:

C1: =A1
C2: =IF(ISERROR(MATCH(0,COUNTIF(C$1:C1,$A$1:$A$20&""), 0)),"",
INDEX(IF(ISBLANK($A$1:$A$20),"",$A$1:$A$20),MATCH( 0,COUNTIF(C$1:C1,$A$1:$A$2
0&""),0)))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

Copy C2 down as far as you need

D1: =SUMIF(A:A,C1,B:B)

and copy down

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"jk" wrote in message
...
I have column A that contains many account numbers and i have column B

which
is a dollar value that corresponds to each account.

A B
10023 $25.00
10024 $20.00
10025 $25.00
10023 $25.00
10026 $25.00
Is it possible to assign cells in column C to sum the amounts which equal
the accounts. For example account 10023 sums up to $50.00 and i would like
each time the account of 10023 is entered into column A ,it would

accumulate
the amount in a cell of column C .........can this be done?