Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF Exclude Certain Cell | Excel Worksheet Functions | |||
sumif if cell does not equal #N/A | Excel Discussion (Misc queries) | |||
SUMIF cell is colored | Excel Discussion (Misc queries) | |||
SUMIF cell = "Yes" | Excel Discussion (Misc queries) | |||
SUMIF, wildcard and cell ref | Excel Worksheet Functions |