Hi All,

Currently having major excel issues. I've got a spreadsheet with multiple columns of data all feeding from different sources, and I need to do an average based on multiple criteria.

So I currently have to sort one column alphabetically so that I can do an average if with the range being the range of few values from the column which i have.

So they currently look like this:
=AVERAGEIF($T$72:$T$222,"Criteria B",$AG$72:$AG$222)
=AVERAGEIF($T$2:$T$71,"Criteria A",$AG$2:$AG$71)

where $T$72:$T$222 is Criteria C, and $T$2:$T$71 is Criteria D
Column AG is where the data I want to average is.

Ultimately I want to make it so that excel will do an average of all the data which has all the criteria required.

Thanks for any help!