If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Accumulate values
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? |
#2
|
|||
|
|||
Accumulate values
jk wrote:
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? You can use the SUMIF function. Check on online help... -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#3
|
|||
|
|||
Accumulate values
I am knew to this and as far as i got was the count if statement that counts
the number of entries in that one column.I need it to sum up the dollar amounts that are associated to the account number in the other column.How do you do this? "Franz Verga" wrote: jk wrote: 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? You can use the SUMIF function. Check on online help... -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#4
|
|||
|
|||
Accumulate values
jk wrote:
I am knew to this and as far as i got was the count if statement that counts the number of entries in that one column.I need it to sum up the dollar amounts that are associated to the account number in the other column.How do you do this? try this: =SUMIF(A:A,A1,B:B) "Franz Verga" wrote: jk wrote: 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? You can use the SUMIF function. Check on online help... -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy -- (I'm not sure of names of menus, options and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using the values of a crosstab query to create new values | relacy | Running & Setting Up Queries | 1 | December 15th, 2005 10:29 PM |
Keeping a cell value constant trhoughout a list of values | borikua05 | Worksheet Functions | 2 | December 3rd, 2005 03:03 PM |
default values in queries | Jeff B | Running & Setting Up Queries | 11 | March 3rd, 2005 12:49 AM |
Average only some values | Andreas | Worksheet Functions | 2 | February 18th, 2004 10:56 AM |
finding distinct values from two lists | Frank Kabel | Worksheet Functions | 0 | February 14th, 2004 12:41 AM |