LinkBack URL
About LinkBacks
Does anybody know how I could combine the formulas below so that I can use the "Subtotal" feature without any "#N/A" errors messing-up the sum?
=SUBTOTAL(9,LI15:LI18)
=SUM(IF(ISERROR(LI15:LI18)," ",LI15:LI18))
Thanks in advance.
Does anybody know how I could combine the formulas below so that I can use the "Subtotal" feature without any "#N/A" errors messing-up the sum?
=SUBTOTAL(9,LI15:LI18)
=SUM(IF(ISERROR(LI15:LI18)," ",LI15:LI18))
Thanks in advance.
Last edited by taketwo; 01-17-2010 at 08:59 PM. Reason: Solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks