Hi,
I think I am using the correct formula for my scenario. I definitely need some guidance.
I need to calculate the average of a range of cells containing different criteria. Attached is a sample of what I am looking for. I think AVERAGEIFS is the formula to use, but could (likely) be wrong.
=AVERAGEIFS(B2:B7,A2:A7,"CD",A2:A7,"DD1",A2:A7,"DD2")
The average being displayed in cell F2 in the attached sample file.
Anyone's help is much appreciated.
Cheers,
Ashley
Bookmarks