I have a spreadsheet that contains contribution data. Each cell in the range
G4 through G780 contain individual contribution amounts.

I would like be able to devise a formula that looks at that entire range,
and then counts the number of occurrances in a certain range. For example:

I need the formula to look at the entire range (G4 through G780), find all
occurrances of values that occur between the values 100 and 500, then produce
a count of those that fall within that range. I would also like a similar
formula that totals the values in that same range.

Any help is GREATLY appreciated.

Happy Thanksgiving!