Hey everyone,

So I have a file with a ton of data in it and I'm trying to find a way to do this without huge formulas for each type because the file is already running slow with big formulas. Here are the columns of data:

A- Type
B- Amount
C- Month
D- Year

So far there are 7 months worth of data and I'm trying to calculate the average monthly total amount for each type (50 different types). I know I can do it with the following formula but doing it for all 12 months of the year makes for a long formula which is what I'm trying to avoid, and I know pivot tables will work, but with all the other stuff I'm doing in the report, it would require multiple pivot tables and I don't want that.

=AVERAGE(SUMIFS(jan2011 criteria),SUMIFS(feb2011 criteria),SUMIFS(mar2011 criteria).....)

Is there a better formula for doing this? Any help would be greatly appreciated. Thanks