Error #DIV/0!

[Tufail]

i am using following formula but when my PMTSN range doesn't have any value
then #DIV/0! error is coming out.

=AVERAGEIF(PMTSN,F260,PMTEXR)

thanks in advance.

 

[Eduardo]

Hi,
Try
=if(PMTSN="","",AVERAGEIF(PMTSN,F260,PMTEXR))
If this was helpful please say yes, thanks

 

[Tufail]

thank you so much.

Hi,
Try
=if(PMTSN="","",AVERAGEIF(PMTSN,F260,PMTEXR))
If this was helpful please say yes, thanks

 

[T. Valko]

Another one:

=IFERROR(AVERAGEIF(PMTSN,F260,PMTEXR),"")