Hello everyone
Say column A has values (some cells may be blank or 0) and cell B1 = sum(A:A).
I would like a macro that will replace B1 with the values being summed, except 0s and blanks.
So for example, col A has values A1=1 , A2=2, A3=(blank), A4=4 . B1 currently = sum(A:A). When the macro is run, B1 becomes =1+2+4
I would really appreciate any help on this.
Last edited by uberathlete; 06-21-2016 at 10:39 AM.
Hi, do you have any vba knowledge?
This quick-and-dirty code will do that for you
Please Login or Register to view this content.
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
this code first sum all values and then replace b1 with sum value
Please Login or Register to view this content.
Kamboj
_________________________________________________________________________________
Mark the thread as SOLVED if my answer satisfy you.
Hi Keebellah
Yes I have some VBA knowledge. Looks like this code gives the final result of the sum formula. I was hoping for something that would change the formula to a sum of the actual values , ie. instead of =sum(A:A), it would become =1+2+4
Maybe:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks