#### nigidivitch

##### New Member

- Joined
- Sep 28, 2010

- Messages
- 22

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!