Hi Oeldere,

Some of the rows/columns are hidden because they are just extra detail -- no impact on the total calculation. I was trying to avoid having to create a pivot table with the data -- I was hoping to try and find a formula that could do it all at once. If I can't find an all-in-one formula, this is definitely a good back-up!

Anyone else know of a method that would be an all-in-one formula to solve this?