Contains a Value Cell and Sumif?
 

Ok I have the follwing:

Col A Col B Col C Col D

Bill Scott $50
Jim Scott $98
Smith Jack $509
Jill Jack $987
Jack Bill $989
Scott Bill $32


I am trying to do this:

Ok I have the follwing:

Col A Col B Col C Col D
Add Totals
For Each Name
Bill Scott $50
Jim Scott $98
Smith Jack $509
Jill Jack $987
Jack Bill $989
Scott Bill $32

I am using this formula =SUMIF(C2:C100,"Scott",D2:D100). That part works
fine. But what I need to do is be able to get what in in Col A where Scott
is so that I can drag my formula down so that it will pull the value from Col
A. I have over 100 names and to type the name in the formula for each person
is too much. Any ideas on this one?

Thank you.

Contains a Value Cell and Sumif?
 

Try it like this:

Entered in B2 then copied down:

=SUMIF(C$2:C$100,A2,D$2:D$100)

--
Biff
Microsoft Excel MVP


"DMB" wrote in message
...
Ok I have the follwing:

Col A Col B Col C Col D

Bill Scott $50
Jim Scott $98
Smith Jack $509
Jill Jack $987
Jack Bill $989
Scott Bill $32


I am trying to do this:

Ok I have the follwing:

Col A Col B Col C Col D
Add Totals
For Each Name
Bill Scott $50
Jim Scott $98
Smith Jack $509
Jill Jack $987
Jack Bill $989
Scott Bill $32

I am using this formula =SUMIF(C2:C100,"Scott",D2:D100). That part works
fine. But what I need to do is be able to get what in in Col A where
Scott
is so that I can drag my formula down so that it will pull the value from
Col
A. I have over 100 names and to type the name in the formula for each
person
is too much. Any ideas on this one?

Thank you.

Contains a Value Cell and Sumif?
 

I tried that...It didn't seem to work...It gives me 0

"T. Valko" wrote:

Try it like this:

Entered in B2 then copied down:

=SUMIF(C$2:C$100,A2,D$2:D$100)

--
Biff
Microsoft Excel MVP


"DMB" wrote in message
...
Ok I have the follwing:

Col A Col B Col C Col D

Bill Scott $50
Jim Scott $98
Smith Jack $509
Jill Jack $987
Jack Bill $989
Scott Bill $32


I am trying to do this:

Ok I have the follwing:

Col A Col B Col C Col D
Add Totals
For Each Name
Bill Scott $50
Jim Scott $98
Smith Jack $509
Jill Jack $987
Jack Bill $989
Scott Bill $32

I am using this formula =SUMIF(C2:C100,"Scott",D2:D100). That part works
fine. But what I need to do is be able to get what in in Col A where
Scott
is so that I can drag my formula down so that it will pull the value from
Col
A. I have over 100 names and to type the name in the formula for each
person
is too much. Any ideas on this one?

Thank you.

Contains a Value Cell and Sumif?
 

Yes that worked...I figured out what I did wrong. I had the last names first
in Col A and in Col C I had the first names first. Made the changes and
works great!

Thank YOU!

"DMB" wrote:

I tried that...It didn't seem to work...It gives me 0

"T. Valko" wrote:

Try it like this:

Entered in B2 then copied down:

=SUMIF(C$2:C$100,A2,D$2:D$100)

--
Biff
Microsoft Excel MVP


"DMB" wrote in message
...
Ok I have the follwing:

Col A Col B Col C Col D

Bill Scott $50
Jim Scott $98
Smith Jack $509
Jill Jack $987
Jack Bill $989
Scott Bill $32


I am trying to do this:

Ok I have the follwing:

Col A Col B Col C Col D
Add Totals
For Each Name
Bill Scott $50
Jim Scott $98
Smith Jack $509
Jill Jack $987
Jack Bill $989
Scott Bill $32

I am using this formula =SUMIF(C2:C100,"Scott",D2:D100). That part works
fine. But what I need to do is be able to get what in in Col A where
Scott
is so that I can drag my formula down so that it will pull the value from
Col
A. I have over 100 names and to type the name in the formula for each
person
is too much. Any ideas on this one?

Thank you.

Contains a Value Cell and Sumif?
 

Good deal. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"DMB" wrote in message
...
Yes that worked...I figured out what I did wrong. I had the last names
first
in Col A and in Col C I had the first names first. Made the changes and
works great!

Thank YOU!

"DMB" wrote:

I tried that...It didn't seem to work...It gives me 0

"T. Valko" wrote:

Try it like this:

Entered in B2 then copied down:

=SUMIF(C$2:C$100,A2,D$2:D$100)

--
Biff
Microsoft Excel MVP


"DMB" wrote in message
...
Ok I have the follwing:

Col A Col B Col C Col D

Bill Scott $50
Jim Scott $98
Smith Jack $509
Jill Jack $987
Jack Bill $989
Scott Bill $32


I am trying to do this:

Ok I have the follwing:

Col A Col B Col C Col D
Add Totals
For Each Name
Bill Scott $50
Jim Scott $98
Smith Jack $509
Jill Jack $987
Jack Bill $989
Scott Bill $32

I am using this formula =SUMIF(C2:C100,"Scott",D2:D100). That part
works
fine. But what I need to do is be able to get what in in Col A where
Scott
is so that I can drag my formula down so that it will pull the value
from
Col
A. I have over 100 names and to type the name in the formula for
each
person
is too much. Any ideas on this one?

Thank you.