sum problem

[jerie]

I have a column "E" ,from row 3 down to row 121.
I need to sum that column,only for the rows that have more
than $1.00 entered
eg:- E
$1.00
$5.00
$7.00
$3.00
$5.00
$1.00

= $20.00 (the two one dollar rows are not counted

thank you all

 

[Biff]

Hi!

Try this:

=SUMIF(E3:E121,">1")

Biff