Hi,
SO I'm running into a complication in formatting and I'm wondering if there is a solution.
So I'm creating a table to find averages. Thus far I have a formula as such:
=E6/(SUMIFS(Table[Column 1],Table[Column 2],"Classification Type",Table[Column 3],">0"))
Because I haven't gotten anything yet to post under a certain classification type in my data, I get the Standard error message "#DIV/0!" when I press enter. Is there a way that I can format it so if the denominator in the equation above = 0, then the whole cell shows 0, but if it DOES have a value >0 that it'll just carry out the formula? I've been looking for hours trying to find a way to do it and just can't!
Thanks!
Bookmarks