Trying to find a formula that QUICKLY counts errors, formula or results, on a SS
I am trying to just count errors in a defind range on my spreadsheet. I tried using an array formula but it killed the processing time. I then tried a UDF, shown below, but it also kills the processing time because it runs more than once when doing a standard calculation. Is there a way to set the formula to only run at the end of a calc cycle?
Thanks!
Please Login or Register to view this content.
Last edited by Uziel; 03-17-2010 at 04:11 PM. Reason: shg told me to :)
Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.
Entia non sunt multiplicanda sine necessitate
Hi,
A UDF will slow you down a touch. How about
=SUMPRODUCT((ISERROR(range))*1)
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
I think that formula has the same problem as the UDF. It takes 2.5 seconds to calculate without the formula. I added the formula, hit calculate, and stopped the calculation when it was at 30% done and 30 seconds into the calculation.... Excel seems to repeatedly calculate both formulas where it only needs to be done once...at the end.
Thoughts?
I think you ought to read my last post.Thoughts?
Sorry shg, I did not even see your post. I will do that right now.
Your title was fine. What I asked is that you add CODE tags.
Third time's the charm.
Try this; code goes in the Sheet module:
Please Login or Register to view this content.
Thank you sir. Just off that one bit of code a learned a NUMBER of new things!
I apologize about the trouble with the post. I am now officially trained.
Did you read the part about marking threads as Solved?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks