| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
a formula to search for names in columns and then add the figures
I need a formula to search for names in columns and then add the figures that
are in a different column, so for example i have names in one column and then need to find each name and add the dollar amounts that are listed in another column... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
a formula to search for names in columns and then add the figures
Easiest way is with SUMIF(). See Excel Help for it for the details.
Basically, identify the cells with names as the first parameter, a cell where you will enter one of the names (or an actual name), as the second parameter and the cells with the numbers to be added as the 3rd parameter. Assume list of names in cells A1, A2, A3, A4, A5 and A6 with some associated numbers in column B on the same rows, and that you can enter any one of the names into C1. This formula would give you total of numbers for the name entered in C1: =SUMIF(A1:A6,C1,B1:B6) "Vercingetorix.I" wrote: I need a formula to search for names in columns and then add the figures that are in a different column, so for example i have names in one column and then need to find each name and add the dollar amounts that are listed in another column... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
a formula to search for names in columns and then add the figures
You can do this using PIVOT Table.
In Excel 2007 Insert- Pivot Table Select the cells containing your data, click on name and dollar amount fields (first row should contain the lables, say Name & Amount. Move Amount to Sum (Sigma symbol) field and in the drop down change field property to Sum "Vercingetorix.I" wrote: I need a formula to search for names in columns and then add the figures that are in a different column, so for example i have names in one column and then need to find each name and add the dollar amounts that are listed in another column... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
a formula to search for names in columns and then add the figures
Thank you, I am going over this site and it is great, I didnt expect to get
an answer so quickly either... "Vercingetorix.I" wrote: I need a formula to search for names in columns and then add the figures that are in a different column, so for example i have names in one column and then need to find each name and add the dollar amounts that are listed in another column... |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
a formula to search for names in columns and then add the figu
Glad we could help you.
JLatham's solution is easier and more elegant. You do need to learn about PIVOT tables... it will save you lot of grief. Try to master VLOOKUP also. "Vercingetorix.I" wrote: Thank you, I am going over this site and it is great, I didnt expect to get an answer so quickly either... "Vercingetorix.I" wrote: I need a formula to search for names in columns and then add the figures that are in a different column, so for example i have names in one column and then need to find each name and add the dollar amounts that are listed in another column... |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
a formula to search for names in columns and then add the figu
Thank you Sheloo, I will do as you advise
"Sheeloo" wrote: Glad we could help you. JLatham's solution is easier and more elegant. You do need to learn about PIVOT tables... it will save you lot of grief. Try to master VLOOKUP also. "Vercingetorix.I" wrote: Thank you, I am going over this site and it is great, I didnt expect to get an answer so quickly either... "Vercingetorix.I" wrote: I need a formula to search for names in columns and then add the figures that are in a different column, so for example i have names in one column and then need to find each name and add the dollar amounts that are listed in another column... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing figures across 2 columns. | Excel Worksheet Functions | |||
| Need Excel formula to separate names into columns, with exceptions | Excel Discussion (Misc queries) | |||
| Have 2 columns of names - need to filter out names not duplicated | Excel Worksheet Functions | |||
| Help with a formula for concatenate and search/find with 3 columns | Excel Worksheet Functions | |||
| How can I find the common names in two columns of names? | Excel Discussion (Misc queries) | |||
Linear Mode
