Gee! Will this never end? (no offence to the poster since I assume he can't
see all previous answers although the date of the original post should shed
some light)

--
Regards,

Peo Sjoblom



"Darby" wrote in message
...
Hi Wendy-

In column E, I created an if statement =IF(A1B1,1,0) in each row that
contains data and then at bottom of data in column D, I created an sumif
statement =SUMIF(E1:E9,"=1",D1:D9).

This seems to do what you want

"Wendy" wrote:

Need help...I am trying to sum only those values in column (D)
whose corresponding value in column (A) is greater than the value in
column (B).

(A) (B) (C) (D)
1. 6,942 292 0.81 5,614.84
2. 317 0 0.92 292.87
3. 6,207 20,374 7.64 47,421.48
4. 417 17,588 5.84 2,435.28
5. 43,921 108,193 1.01 44,525.47
6. 5,974 15,883 3.11 18,579.14
7. 1,834 7,062 1.79 3,283.57
8. 665 733 2.13 1,416.76
9. 21,855 24,149 1.70 37,153.00

Any suggestions? I've been struggling with this for the past few days.


--
Wendy