Sum based on specific condition

[Peo Sjoblom]

LOL! That was just the 35th answer, do you really think a simple question
like that would have been left unanswered for 48 hours? How about getting a
newsreader?

 

[Guest]

Someone else might have a more elegant way of doing this, but here's what I'd
do:

In cell E1, put: =if(a1>b1,d1,0). Then sum column E instead of column D to
get your total.

Hope this helps!

Sam.

 

[Guest]

Try

=SUM(IF(B1:B9>A1:A9,D19))

after typing the above press CTRL+SHIFT+ENTER instead of simple enter

 

[Harlan Grove]

LOL! That was just the 35th answer, do you really think a simple
question like that would have been left unanswered for 48 hours?
How about getting a newsreader?

....

What?! There might be something better than Microsoft's own web site?!