LumberJocks

eCabinets cut list in excel #9: Use SumIfs in VBA to total the filtered data from the eCabinets five piece door breakdown.

  • Advertise with us
Blog entry by ScottM1 posted 10-31-2015 09:10 PM 765 reads 0 times favorited 0 comments Add to Favorites Watch
« Part 8: Advanced filter in Vba to summarize your eCabinets Cut list in excel. Part 9 of eCabinets cut list in excel series Part 10: Convert numbers stored as text in your cut list with excel vba Part1 »

In this video I will show you how I used the SumIfs function in VBA to total the door/drawer front parts in the filtered data that was created using the advanced filter in VBA.

Here is the link to check it out.
https://youtu.be/XTD746yFCCw

-- Scott Marshburn,https://www.youtube.com/user/ecabinetstips, FaceBook, https://www.facebook.com/ecabinetstipsandtricks, Twitter, https://twitter.com/eCabinetstips



0 comments so far

Have your say...

You must be signed in to post the comments.

DISCLAIMER: Any posts on LJ are posted by individuals acting in their own right and do not necessarily reflect the views of LJ. LJ will not be held liable for the actions of any user.

Latest Projects | Latest Blog Entries | Latest Forum Topics

HomeRefurbers.com