Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ok which Sum... formula to use
Help please....
Ok I need to figure out how to get column A to condense to column C and the totals from Column B to sum up in column D. Column A&B is 66 cells long. Sorry if this is to vauge, if need more info post. A B c d 123456789 300 123456789 600 1234567890 1000 1234567890 3000 0 1508430 324 0 123456789 300 1234567890 1000 0 0 1508430 324 1234567890 1000 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
ok which Sum... formula to use
In Cell D1 put this formula and drag it down
=SUMIF(A$1:A$10,$C1,B$1:B$10) On Jan 28, 10:57*am, Lost wrote: Help please.... Ok I need to figure out how to get column A to condense to column C and the totals from Column B to sum up in column D. Column A&B is 66 cells long. Sorry if this is to vauge, if need more info post. * * * * A * * * * * * * * * * * * B * * * * * * * * * * * * * * * c * * * * * * * * * * * * * *d 123456789 * * * 300 * * * * * * * * * * * 123456789 * * * * * * * * *600 * 1234567890 * * *1000 * * * * * * * * * * 1234567890 * * * * * * * * 3000 * * * * 0 * * * * * * * * * * * * * * * * * * * * * * * * * 1508430 * * * * * * * * * * *324 0 * * * * 123456789 * * * 300 1234567890 * * *1000 * * 0 * * * * 0 * * * * 1508430 * * * * * * * * 324 1234567890 * * *1000 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
ok which Sum... formula to use
thanx, works great. I got one more for ya. How do i eliminate double lots
being pulled over from column A to column C so i get this? A B c d 123456789 300 123456789 600 1234567890 1000 1234567890 3000 0 1508430 324 0 123456789 300 1234567890 1000 0 0 1508430 324 1234567890 1000 And not.... A B c d 123456789 300 123456789 600 1234567890 1000 1234567890 3000 0 1508430 324 0 123456789 600 123456789 300 1234567890 3000 1234567890 1000 1508430 324 0 0 1508430 324 1234567890 1000 "muddan madhu" wrote: In Cell D1 put this formula and drag it down =SUMIF(A$1:A$10,$C1,B$1:B$10) On Jan 28, 10:57 am, Lost wrote: Help please.... Ok I need to figure out how to get column A to condense to column C and the totals from Column B to sum up in column D. Column A&B is 66 cells long. Sorry if this is to vauge, if need more info post. A B c d 123456789 300 123456789 600 1234567890 1000 1234567890 3000 0 1508430 324 0 123456789 300 1234567890 1000 0 0 1508430 324 1234567890 1000 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
ok which Sum... formula to use
go to data | filter | advance filter | choose copy to another location
| List range = $A:$A | copy to : $C$1 | check unque records only | ok On Jan 28, 1:21*pm, Lost wrote: thanx, works great. I got one more for ya. How do i eliminate double lots being pulled over from column A to column C so i get this? * * * *A * * * * * * * * * * * * B * * * * * * * * * * * * * * * c * * * * * * * * * * * * * d *123456789 * * * 300 * * * * * * * * * * * 123456789 * * * * * * * * *600 * *1234567890 * * *1000 * * * * * * * * * * 1234567890 * * * * * * * * 3000 * * *0 * * * * * * * * * * * * * * * * * * * * * * * * * 1508430 * * * * * * * * * * *324 *0 * * * * *123456789 * * * 300 *1234567890 * * *1000 * * *0 * * * * *0 * * * * *1508430 * * * * * * * * 324 *1234567890 * * *1000 And not.... * * * A * * * * * * * * * * * * B * * * * * * * * * * * * * * * c * * * * * * * * * * * * * *d *123456789 * * * 300 * * * * * * * * * * * 123456789 * * * * * * * * *600 * *1234567890 * * *1000 * * * * * * * * * * 1234567890 * * * * * * * * 3000 * * *0 * * * * * * * * * * * * * * * * * * * * * * * * * 1508430 * * * * * * * * * * *324 *0 * * * * * * * * * * * * * * * * * * * * * * * * *123456789 * * * * * * * * * 600 *123456789 * * * 300 * * * * * * * * * * * *1234567890 * * * * * * * *3000 *1234567890 * * *1000 * * * * * * * * * * * 1508430 * * * * * * * * * * 324 *0 * * * * *0 * * * * *1508430 * * * * * * * * 324 *1234567890 * * *1000 "muddan madhu" wrote: In Cell D1 put this formula and drag it down =SUMIF(A$1:A$10,$C1,B$1:B$10) On Jan 28, 10:57 am, Lost wrote: Help please.... Ok I need to figure out how to get column A to condense to column C and the totals from Column B to sum up in column D. Column A&B is 66 cells long. Sorry if this is to vauge, if need more info post. * * * * A * * * * * * * * * * * * B * * * * * * * * * * * * * * * c * * * * * * * * * * * * * *d 123456789 * * * 300 * * * * * * * * * * * 123456789 * * * * * * * * *600 * 1234567890 * * *1000 * * * * * * * * * * 1234567890 * * * * * * * * 3000 * * * * 0 * * * * * * * * * * * * * * * * * * * * * * * * * 1508430 * * * * * * * * * * *324 0 * * * * 123456789 * * * 300 1234567890 * * *1000 * * 0 * * * * 0 * * * * 1508430 * * * * * * * * 324 1234567890 * * *1000- Hide quoted text - - Show quoted text - |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
ok which Sum... formula to use
hmmm.....
It appears that since i use a formula to pul these numbers from another sheet the filter option isnt working "muddan madhu" wrote: go to data | filter | advance filter | choose copy to another location | List range = $A:$A | copy to : $C$1 | check unque records only | ok On Jan 28, 1:21 pm, Lost wrote: thanx, works great. I got one more for ya. How do i eliminate double lots being pulled over from column A to column C so i get this? A B c d 123456789 300 123456789 600 1234567890 1000 1234567890 3000 0 1508430 324 0 123456789 300 1234567890 1000 0 0 1508430 324 1234567890 1000 And not.... A B c d 123456789 300 123456789 600 1234567890 1000 1234567890 3000 0 1508430 324 0 123456789 600 123456789 300 1234567890 3000 1234567890 1000 1508430 324 0 0 1508430 324 1234567890 1000 "muddan madhu" wrote: In Cell D1 put this formula and drag it down =SUMIF(A$1:A$10,$C1,B$1:B$10) On Jan 28, 10:57 am, Lost wrote: Help please.... Ok I need to figure out how to get column A to condense to column C and the totals from Column B to sum up in column D. Column A&B is 66 cells long. Sorry if this is to vauge, if need more info post. A B c d 123456789 300 123456789 600 1234567890 1000 1234567890 3000 0 1508430 324 0 123456789 300 1234567890 1000 0 0 1508430 324 1234567890 1000- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|