Sum based on specific condition
Hi Wendy,
I think the easiest way would be to put =IF(A1B1,D1,"")
in helper column E and drag down to the end of your data,
and then sum column E. You can then hide column E or use
a different helper column way off to the right somewhere
or even on a separate sheet if you wish.
HTH
Martin
"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
|