sumif ???

  • Thread starter Thread starter bill gras
  • Start date Start date
B

bill gras

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top