Another one:

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


--
Biff
Microsoft Excel MVP


"Tufail" wrote in message
...
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.