Calculating totals from one column on the basis of a condition in another

Hi

I've been worrying at this problem for a while and can't seem to get past it.

I have a workbook that captures information about tutorials and workshops given by support tutors to students at my university. Each tutor has their own worksheet on which they record information about the students they meet, subjects discussed, type of tutorial, time spent, etc. in a shared workbook.

I want to be able to return totals of time spent on each tutorial type by each tutor on a summary page elsewhere in the workbook. I have attached a simplifed exampel for illustrative purposes.

For each tutor's worksheet, among other colums containing different information, one column (Type) can be populated with 3 options: Face-to-face; Remote: Workshop

The adjacent column (Duration) records the time in minutes spent on each activity:

So for each tutor I would be able to see the total times they had spent doing remote support, face-to-face support and conducting workshops in a month (probably around 60 individual entries each).

The tutor in the example above would have have spent 150 minutes conducting remote tutorials, 60 minutes conducting face-to-face tutorials, etc.

Any ideas how I might do this. I've been experimenting with VLOOKUP, OFFSET and MATCH but am lamentably out of my depth. The problem seems particularly to be that I need to do this multiple times in the same column - i.e., I need to go and find all of the instances of, say, 'remote' and capture the time recorded in the same rows in the 'Duration' column and then add all of the times together.

All suggestions gratefully accepted.

With thanks

John
(Pads)