I have an interesting problem, and I feel like I'm over thinking it by too much...
I need to return the sum of all values in a table that meet certain base criteria... I've attached an example.
I need to return the sum so I can average all of the numbers together. The numbers are percentages, and I want the average percentage based on these values.
In this example I want to return the Sum of all Cells that intersect with a column AND row that are = to A. Once I figure this out, I can apply it to my spreadsheet accordingly and do so for each... There are 9 potential references if that helps at all...
Bookmarks