amazing, thanks! - this is great. Just wondering when I "summarize with pivot table" i don't have the option to filter by template.

Also, just curious how you learned all this? I was looking at the named ranges and formula you used, I could never have thought this up