Thread: #DIV/0! Error - Need to display 0 or blank
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Chip Pearson Chip Pearson is offline
external usenet poster
  
Posts: 7,247
Default #DIV/0! Error - Need to display 0 or blank
Try

=IF(J2=0,0,SUMIF(A2:A98,I2,F2:F98)/J2)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)

"Brooks W." wrote in message
...
I have the following formula used to compare a list of vendors to entered
data and the make the calculation.

=SUMIF(A2:A98,I2,F2:F98)/J2

I want the cell to display either blank or 0. Is there a quick way to
changer this without using the ISERROR function?

There are currently 32 cells with this formula and could be added to as we
add vendors.

Thanks for any insights.
--
Brooks W.


Reply With QuoteReply With Quote