ExcelBanter - sum problem

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sum problem (https://www.excelbanter.com/excel-discussion-misc-queries/15136-sum-problem.html)

jerie

sum problem

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

-----Original Message-----
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

.

All times are GMT +1. The time now is 04:09 AM.