LinkBack URL
About LinkBacks
Hi,
I am currently stuck with a formula to only do a SUMIF on only visible cells,
Is there another way to do it, I have tried to do a subtotal,109 but that will not work.
Any help would be appreciated
Please Login or Register to view this content.
Hi,
I am currently stuck with a formula to only do a SUMIF on only visible cells,
Is there another way to do it, I have tried to do a subtotal,109 but that will not work.
Any help would be appreciated
Please Login or Register to view this content.
not sure what you are trying to do, but have you tried using sumifS()?
if that is not what you need, then perhaps it would be easier to help you if you uploaded a sample workbook, showing what data you are working with, a few examples of what your expected outcome would be, and how you would arrive at that (remove any confidential info if necessary).
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
If you are having trouble with subtotal() and it is because of syntax...this will help:
http://www.ozgrid.com/Excel/excel-subtotal-function.htm
Of course, if your situation does not allow for subtotal, then that will likely not help too much, and posting an example of your issue would help us figure out what to do next.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks