Thanks for the feedback, Jack....I'm glad I could help.

***********
Regards,
Ron

XL2002, WinXP


"Jack Taylor" wrote:

Ron:

Perfect! Many thannks for your help!

"Ron Coderre" wrote:

Try these:

With
G4:G780 containing numbers

Then
A1: 100
A2: 500

This formula counts the G4:G780 values that are between 100 and 500,
inclusive.
A3: =COUNTIF(G4:G780,"="&A1)-COUNTIF(G4:G780,""&A2)

This formula sums those amounts:
A4: =SUMPRODUCT((G4:G780=A1)*(G4:G780<=A2)*(G4:G780))

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Jack Taylor" wrote:

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!