I have column E and rows 3:124 (income)
I have column H and rows 3:124 (outlay)
I need column H total outlay only if column E has more than
$1.00 per row e.g. E H
1 $2.00 1 $29.00
2 $2.00 2 $26.00
3 $1.00 3 $31.00
4 $1.00 4 $31.00
5 $4.00 5 $45.00
6 $1.00 6 $31.00

Total $100.00

can any one please help ? Thanks a lot

rgd bill gras

I think this does what you want:
=SUMIF($E$3:$E$124,"1",$H$3:$H$124)

Regards,
Ron

Firstly, I'd be concerned that your selling everything at a BIG loss.

Then i'd do what Ron said

"bill gras" wrote:

I have column E and rows 3:124 (income)
I have column H and rows 3:124 (outlay)
I need column H total outlay only if column E has more than
$1.00 per row e.g. E H
1 $2.00 1 $29.00
2 $2.00 2 $26.00
3 $1.00 3 $31.00
4 $1.00 4 $31.00
5 $4.00 5 $45.00
6 $1.00 6 $31.00

Total $100.00

can any one please help ? Thanks a lot

rgd bill gras