Formulas, Excel 2000

[Guest]

Hi
Trying to figure how to write up an if-then formula?
eg. if d7:d23=12,50 then d7:d23*b7B23 and then the sum of them as well.

Is this possible?
Thanks in advance.

Lee

 

[JE McGimpsey]

One way:

=SUMPRODUCT(--(D723=12,5);D723;B7:B23)

Another

=SUMIF(D723;12,5;B7:B23)*12,5

 

[Guest]

Hi JE McGimpsey

Thanks for your answer - will try it out and see what happens!

Ciao Lee

"JE McGimpsey" skrev: