I have a sheet with a column H of calculated KWhr. If the power is off the cell is blank. If the power is on energy consumption data is collected over time. I have found the rows where the day starts and stops. I wish to Sum the column between those two rows. There are thousands of rows of blanks and thousands of rows with values. For example, day one starts at row 2, data starts at row 2617. Data stops at row 8285, and the range ends at row 11,850. On another day it might be 10,000 rows or 15,000 rows appart. I have several days of data. So I wrote a macro to loop through each day to Sum all of the values in that days range, and place the sum in specific cells for each day. When I run the macro, all the variables get populated and I don't get any errors, but for some reason, that I am not seeing, the result of every Sum is 1 for every day period. A sample data file would be too large to submit. Can someone see anything wrong with the code that I have written.
Bookmarks