Hi, need a bit of help. I don't know if there is a simple solution to this or whether it requires a more complex function/programming.

I have a workbook with a number of worksheets. On each worksheet is something like:

- id - value - type

In 'type' I can enter anything, it's a bit like a category.

What I'd like to do is on a separate worksheet to collate all the entries in 'type' and then sum the 'values' against them.

How can I do this?

Thanks