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!
Bookmarks