| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum values in columns based on values in named range
Hi,
hopefully i´m not in the wrong place to ask this. I have a worksheet with a named range (people) currently 6 values there, one column with lots of different values (Col D), and another column with numbers (Col G). What i want to do is to sum values in Col G based on if Col D contains any of the values in the named range "People". tried SUMIF(D:D;people;G:G) and such, but i cant figure it out. I´m probably just too stupid to see the obvious, but i really need help. Best regards, Mikael |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Named range not continuous. How to display values? | Excel Worksheet Functions | |||
| Named range changes values | Excel Discussion (Misc queries) | |||
| Add up a column based on values in other columns | Excel Worksheet Functions | |||
| looking up values in 1 column based on 2 other columns | Excel Worksheet Functions | |||
| Counting based on values in two columns? | Excel Worksheet Functions | |||
Threaded Mode
