greater/less than formula?

[JENNYC]

Hello...this is hopefully something very easy for one of you experts to answer for me:

I am in need of 2 different formulas.

1. Counting the numbers in Column A that are greater than 60, but less than 90.

2. Give me the sum of the amounts in column B, when it sees a number in column A that is greater than 60, but less than 90.

Please help if you can!! greatly appreciated!

[widemonk]

I think you would have to have a formula for each line. Lets say for instance, your list has 20 items, C1 would need something like this, copied down to C20:-

=if(and(A1>60,A1<90),1,0)

Then

In C21,
=countif(C1:C20,1)

In B21,
=sumif(C1:C20,1,B1:B20)