Summing up Data
On Jan 15, 8:41*am, "Don Guillett" wrote:
Try incorporating an IF ie:
=IF(I3="total",AVERAGE(IF(A2:A22=H3,C2:C22)),AVERA GE(IF((A2:A22=H3)*(B2:B22=I3),C2:D22)))
Thanks! That does work great....
However (ugh), I should probably give you the FULL scope of what we
are doing:
There are EIGHT selection criterias.
So it isn't just Country & Type - it's Country, Type, Field3, Field4,
Field5, Field6, Field7, Field8
They can select "Total" for any or all of the fields, or any
combination of the fields. (IE, they can select All countries, All
Types, All Field 6s...but then break it down within Field3, Field4,
Field5, Field7, Field8).
So using the IFs will make for an extremely large formula; one with a
LOT of possibilities - not sure if Excel could even handle such a
thing.
I just wish there was a way within the AVERAGE(IF where I can use a
wildcard or something that says "Show all records if Total is Selected
for this particular field". It's pretty much trying to get Excel to
mimic the auto-filter feature...which I understand is what Average(IF
does, but perhaps not to the extent needed here.
I could send you the file if you wanted to take a closer look at what
I am doing....
Tom
|