Excel 2007 : Issue with SUMIF formula

[kelvintanhk]

Dear Saviour,

With this formula =SUMIF(E3:E102,1,T3:T102)/C107, when the data is blank it will show #DIV/0!. How can I change the #DIV/0! to a blank cell?

Tried adding iserror formula to it but no luck or maybe not skill enough. Hope someone can help.

Thanks

Regards
Kelvin

[DonkeyOte]

Either:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

the former will catch more than #DIV/0! errors however which may / may not be preferable

also note the former is not backwards compatible pre XL2007

[kelvintanhk]

You are good... Thanks for solving this issue...