ExcelBanter - Error #DIV/0!

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Error #DIV/0! (https://www.excelbanter.com/excel-discussion-misc-queries/214501-error-div-0-a.html)

Tufail

Error #DIV/0!

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

Error #DIV/0!

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

"Tufail" wrote:

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.

Tufail

Error #DIV/0!

thank you so much.

"Eduardo" wrote:

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

"Tufail" wrote:

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.

T. Valko

Error #DIV/0!

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.

All times are GMT +1. The time now is 08:56 PM.