Count and Sum function
Sample data
sheet1
2280<-50.00, Tot amt, # of Rec.
???.?? ???
2280 50<500 ??.?? ??
sheet2
Col A Col B
2280 24.58
4125 2008.10
2280 150.30
4123 0 .03
Now I'll try to explain the best I can.....
I need to find all of the records that contain "2280" and determine which
range the amt falls into. 0-50, 50-500, 500. Then I need to count the
number of records and sum the amt for each different range. The records
that I am searching are on the second sheet and each different range of amt
has a different display cell so I don't need a formula that contains all the
ranges at once. Just one range of amt at a time.
Then of course I need to do that for each different number in col A.
Hope you can help
|