I'm trying to DCOUNT with multiple criteria - but with one of the criteria changing.

I have a list with ..

Date - ID - Name - Data - Type


Where there are many "transactions" for each ID over a month.

I advance filter the ID's over to a new sheet - and I'm trying to get a new list

like...

ID - Combined Data

but only for a certain 'Type'

Basically I can do it with DSUM with multiple criteria...

ID - Type

but I have to change for every ID - or have a criteria listed for every ID which is more than annoying seeing the ID list changes depending on the month of Data I pull into it.

Sorry if this is confusing - I am probably thinking about this in the wrong way - and there is probably a simpler way of doing it.