sumif ???
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 |
All times are GMT +1. The time now is 01:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com