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

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

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

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 -

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 -