Not getting the value in cells of a range passed to a function

Hi here is the code for a simple add with criteria that I am trying to debug in excel

Please Login or Register  to view this content.

the spreadsheet has columns a and b with data from row 2 through 26
when i reach row 5 in the sqft column (b) there is a 5 so I add the amount to
the function name and go to the next row. There is a 5 that I entered in rows 13 and
row 24 but the function doesn't see those values. It sees only old data that I entered in the cells or
what is in the sales column (I'm not really sure what it is looking at) I query the sqft.cells(row, column) and it doesn't see
the 2 fives that I entered. I can't really figure out what is wrong. I have saved the code in the module and saved and closed and
reopened the spreadsheet but it still doesn't work.

Try this. When you use the syntax sqft.cells(row,column), The row and column are not absolute references. They are relative to the sqft range.

Please Login or Register  to view this content.

Or just this...

Please Login or Register  to view this content.