• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

how do i AUTOSUM cells contains formulas in it?

N

nicholes

New Member
i have to autosum a column but it has formulas in it


=INDEX(Sheet2!L5:L24,MATCH(nuru!B5,Sheet2!M5:M24,0),0)


i want autosum it i get error #N/A how can i get autosum???
 
To clarify, the issue is not that there are formulas in the cells, but that some of your cells are returning errors due to the MATCH function not being able to find a match. You can "trick" XL into ignoring the errors using SUMIF. Something like this should work:

=SUMIF(A:A,"<1e99")


The 1E99 is simply an arbitrarily large number. It's just there to force the function to only look at numbers, and ignore the errors.
 
You must log in or register to reply here.
Back
Top