Hello everyone
I have data in columns .. I need to use sumproduct function and get the results for visible rows only
Is that possible by formulas or I have to use vba codes?
Hello everyone
I have data in columns .. I need to use sumproduct function and get the results for visible rows only
Is that possible by formulas or I have to use vba codes?
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
You could use SUBTOTAL(109,range here). That only looks at the visible rows.
Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.
<---Click * Add Reputation for all helpful comments. It's like giving a smile.
Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
How can use subtotal with sumproduct ?
It doesn't work the same, but it could be possible to redesign the formula you are using. Sumproduct doesn't have a way to filter out the cells that aren't visible.
If you post a sample of your worksheet with your formula and the expected results, it may be possible to figure out a different way of doing what you want without using sumproduct. If VBA is required your sheet could also help someone write that code as well.
Thanks sir for your reply
I have found solution by using UDF function
Here's the link
http://www.excelforum.com/excel-prog...t=#post4123198
Nice job. Thanks for sharing the link.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks