I have a macro with a SumIf formula to sum cells in column B if data in column C is greater than 1, which works great (see below). This formula only works correctly if there are 1524 rows in the sheet. Trying to change the code below to work on any length spreadsheet. I have several sheets that range from 500 to 5,000 rows of data. Thanks.
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!