Help with Sum Visible Cells Only ignore errors

[slsimmons]

Good afternoon!

I am hoping to find a quick answer. I am hoping Excel 2010 is able to do this. I know I can use the =SUBTOTAL(109,AT3:AT65497) function to sum visible cells. I also know I can use the =Sum_Visible_Cells(AS4:AS60000) to sum visible cells and I can use the =SUMIF(AR4:AR60000,">0") function to ignore cells with #DIV/0.

Is there a nested IF function I can use to SUM VISIBLE CELLS ONLY IGNORING THOSE WITH #DIV/0?

Any help is greatly appreciated!!

Thanks!
SS

 

[Haseeb Avarakkan]

Hi,

Since you have Excel 2010, check out AGGREGATE Function. I don't have 2010, So I don't know how to help you. But just check the help. it will give you an idea.

 

[slsimmons]

Worked perfectly!!! Thank you so much!!