Sums in Numbers are not adding correctly

I think I may have figured it out = =tho it doesn't explain totally why == I went back to the original document = it did have a couple of rows with $1mil+ items in them = I did not delete them, I only hid them, figuring the Sum would be of the rows I saw and not the whole document == but apparently SUM will add up all the rows, hidden or not -- so if the ## is wrong it's because of hiding a row and not deleting it == When I went back and deleted the hidden rows the total was correct.

Rather irritating really that in order to do proper sums one can't just hide data but. has to totally delete it.

Thank you - the formula is the one in the image above = I just highlighted from H2 through H37 and still get the $2mil figure == no cells from elsewhere highlighted = only the ones in that row -- most of the ## in the cells are $500 which is why I know we're nowhere near $2mil.

I did just divide the chart into 3 subparts and do Sum additions on the columns within each part == the first two were just fine but the last one ends up with $48K and some cents even tho there are no cents at all in the numbers and the total is really about $7K - I did copy over those 10 or so numbers to a fresh column and added them up and they came out correctly!!! -- so there is something messed up in those items =- but can't understand what ==

I just tried it several times == and get the red triangle - I'm doing =SUBTOTAL (36,H) - 36 being the last row [36th] in the column and the column designation being "H" -- the FX before I click on it says SUBTOTAL (36, "Net Dollar Amount") and when I click it get the red triangle == must be doing something wrong. I'm not even getting that $2mil figure. I'll keep working on. it - thanks for the lead.

I went to the online Functions Help section - I have put in =SUM, =SUBTOTAL followed by (109,H) and keep getting the triangle - BUT -- on looking at the examples further it made more sense and it worked!!! I was putting in the range wrong but once I corrected that it worked.

Thank YOU!!!