Is there an easy way to sum a vlookup search in one formula?

[nigidivitch]

Is there an easy way to sum a vlookup search in one formula?

I have a dataset where column A is a list of tasks, column B is a list of names, columns C to N are represent Jan to Dec, and the data within columns B to N represents the number of days that the person in column B spent on the task in column A. The people (in cloumn B) can work on more than one task (column A).

I want to create a summary totalling each person's total, per month, so am trying to create a formula that looks for all instances of [name 1] in column B, and then sums all appropriate values in column C...

...but I'm stuck!

Any help would be very very useful indeed!

 

[T. Valko]

Is there an easy way to sum a vlookup search in one formula?

I have a dataset where column A is a list of tasks, column B is a list of names, columns C to N are represent Jan to Dec, and the data within columns B to N represents the number of days that the person in column B spent on the task in column A. The people (in cloumn B) can work on more than one task (column A).

I want to create a summary totalling each person's total, per month, so am trying to create a formula that looks for all instances of [name 1] in column B, and then sums all appropriate values in column C...

...but I'm stuck!

Any help would be very very useful indeed!

Something like this...

Let's assume your data is on Sheet2 in the range A2:C100.

On your summary sheet...

A2 = some name

=SUMIF(Sheet2!B$2:B$100,A2,Sheet2!C2:C100)