I have worksheet where there are strikthrough rows .
My goal is sum at column E amount of that are not strike through. that is giving me the total amount of numbers that are not strike through.
Column E is dynamic
I have worksheet where there are strikthrough rows .
My goal is sum at column E amount of that are not strike through. that is giving me the total amount of numbers that are not strike through.
Column E is dynamic
I think you will need a macro to do what you want. Delete the formula in E12 before running the macro
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
Perfecto save me from a tedious task
Glad it worked out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks