Forum menu
[Closed] Excel vlookup and summing results
I have a spreadsheet with a list of about projects in column A, Resource name in column B, Days Allocated for Oct, Nov and Dec in columns C, D & E. Where there are multiple resources for a single project the project name is repeated for each one. Each resource can work on multiple projects.
I need to add a project Summary sheet that shows one row per project with the sum of the days allocated for each month.
I also need a resource summary spreadsheet that shows one row per resource with the sum of the days allocated for each month.
So far I have tried vlookup but only get the first occurrence brought back as a match rather than the sum of all occurances
Pivot Table would be the easiest way, you could use DSUM as well
SUMIF sounds like the function you want? You can filter/select on one column and add the number in another column.
SUMIFS can use multiple conditions if you need that (I think)
Sounds like a pivot table job if I understand it correctly
If not I'd add another Column and sum it in there - it's a pretty simple sumif statemen
Sumifs is exactly what you want. Or a pivot table.
Sounds like SUMIFS to me, cos pivot tables are evil.
Pivot Table works. Thanks
cos pivot tables are evil
Like most things in excel, they're great for what they're supposed to do, they're shocking for what they're used for 90% of the time.
SUMPRODUCT if you want something other than a pivot table?