| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
summing up contents on ceratin cells depending on selection criter
I have a worksheet with 4 columns an may rows. Column B and C have Lastname
(Column B) and First Name (Column C) in Column D I have a value lets say a dollar amount. I would like to write a formula were I want to look for "Smith" "Joe" and sum up the "Dollars". I can have many entries for "Smith Joe". I tried the sum with the If but does not seem to work. |
|
#2
|
|||
|
|||
|
Hi Charles,
Try this one: =SUMPRODUCT((B1:B100&C1:C100="SmithJoe")*D1:D100) or =SUMPRODUCT((B1:B100="Smith")*(C1:C100="Joe")*D1:D 100) Regards, KL "Charles" wrote in message ... I have a worksheet with 4 columns an may rows. Column B and C have Lastname (Column B) and First Name (Column C) in Column D I have a value lets say a dollar amount. I would like to write a formula were I want to look for "Smith" "Joe" and sum up the "Dollars". I can have many entries for "Smith Joe". I tried the sum with the If but does not seem to work. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change a cell's contents to it's formula's value? | Excel Worksheet Functions | |||
| Macro to remove contents of cell and move all other contents up one row | Excel Discussion (Misc queries) | |||
| Summing non-contiguous cells | Excel Worksheet Functions | |||
| How to get excel cells to change colors depending on value | Excel Worksheet Functions | |||
| How do I automatically shade cells depending on data entered? | Excel Worksheet Functions | |||
Linear Mode
