I already defined Sum value in H120 cell as =sum(H1:H119) Now I want delete three rows in H column: H2, H8, H67 because it has no data in it. Will it disturb by sum function?
I already defined Sum value in H120 cell as =sum(H1:H119) Now I want delete three rows in H column: H2, H8, H67 because it has no data in it. Will it disturb by sum function?
If you try your question on a copy of your sheet you will see the result.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
as mentioned, try it and find out (but no, you will not "break" teh SUM)
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks