Averageif Statement

[DarrenF]

I'm unsuccessful at using the below formula to average the numbers in column V, but need to set certain criteria. I'll try and break it down to make sense.

=AVERAGEIFS(DATA!$I:$I,">="&$A$2,DATA!$I:$I,"<="&$C$2,DATA!$F:$F,"*Home Internet*",$V:$V)

DATA!$I:$I,">="&$A$2,DATA!$I:$I,"<="&$C$2 is my date range. Example: Between 6/21/2020 and 6/27/2020

DATA!$F:$F,"*Home Internet*" is only Home Internet ticket types

$V:$V based on the 2 above column criteria average only the criteria numbers in column V should be averaged.

 

[Eric W]

For an AVERAGEIFS, you need to put the average range first:

=AVERAGEIFS($V:$V,Data!$I:$I,">="&$A$2,Data!$I:$I,"<="&$C$2,Data!$F:$F,"*Home Internet*")

And is the $V:$V column not on the Data sheet too?

 

[DarrenF]

Yes, it is. It tried DATA!$V:$V, but that didn't work.

 

[DarrenF]

that worked, thank you

 

[Eric W]

Glad it works for you, thanks for the update.