Hi there,
I am trying to calculate for a sum on a filtered range with the help of a customer defined function.
In cell D1, I have:
Please Login or Register to view this content.I am getting a "NAME?" error. I am not sure if it is syntax error or something missing in the custom defined function code.Please Login or Register to view this content.
Anybody able to assist?
Last edited by Lifeseeker; 02-22-2012 at 11:06 AM. Reason: additional help required
Hi,
Why are you even bothering with an inefficient looping user defined function when there is a perfectly simple bog standard Excel function.
E1: =SUBTOTAL(9,B3:B17)
Never use VBA when you can use standard Excel functionality. It's generally much slower, particularly if loops are involvedand can sometimes react not as you imagine.
Regards
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
ah I see. Actually, I just found out about that as well....
What about if I wanted to do a median() calculation on filtered range? Will that require a custom function or?
Thank you
got it to work using this, but it might inefficient I suppose?
Please Login or Register to view this content.
Hi,
Not as inefficient as a looping UDF!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks