Site Count

[AndyK1810]

I have 10,000 assets listed across 140 sites, each asset have varying frequency. I would like to count the number of sites that each asset type exists on based on there frequency and task type
In the example I've created all the information is in one TAB however in my spreadsheet the the criteria exists across multiple TABS

Thank you in advance