#DIV/0! - I don't want it to show up in my cells

[Lwamp]

I have attached a sample of my workbook. I am wanting the formula I currently have in cells BE10 and BE11 but I don't want them to show DIV/0 if the cells they pick their data up from are empty.

[AliGW]

What do you want it to show?

=IFERROR(SUM(C8,L8,U8,AD8,AM8,AV8)/(BD8*830),0)

will return 0.

=IFERROR(SUM(C8,L8,U8,AD8,AM8,AV8)/(BD8*830),"")

will return a blank.

=IFERROR(SUM(C8,L8,U8,AD8,AM8,AV8)/(BD8*830),"your_message")

will return bespoke text.

[Lwamp]

Thank you very much!

[AliGW]

No problem.

[Lwamp]

If I didn't want to put data in like I left out in cell AV10 how would I make cell BE10 stop picking up zero percentage? I'd only like BE10 to divide by BD10*830 only if it picks up data that are in the cells like AV10. I have reattached an updated workbook.

[AliGW]

This maybe?

=IF(COUNT(C10,L10,U10,AD10,AM10,AV10)=6,IFERROR(SUM(C10,L10,U10,AD10,AM10,AV10)/(BD10*830),""),"")

[Lwamp]

Hmm I tried that and placed 6400 into cell AV10 to see what would come up in BE10 and it just stays blank. I attached what I tried.

[AliGW]

You implied that all of those 6 cells needed something in them.

Please explain more fully and in detail EXACTLY what you are trying to do. At the moment, it feels a bit like one of those pictures that is revealed bit by bit, and we're not yet seeing the whole thing.

I don't like shifting goalposts (they are a time-waster), so I'll wait now until you've given the whole story.

And you need to remove the SOLVED tag!

[JohnTopley]

In BE8

=IFERROR(SUMPRODUCT(($C8:$BB8)*($C$4:$BB$4="Weld"))/($BD8*830),0)

Change "Weld" to appropriate headings BJ,BJ,BK

You can hide zeros with this format:

0;-0;;@