Formulas, Excel 2000

L

Lee

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
 
J

JE McGimpsey

One way:

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

Another

=SUMIF(D7:D23;12,5;B7:B23)*12,5
 
L

Lee

Hi JE McGimpsey

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

Ciao Lee

"JE McGimpsey" skrev:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Can't Add 16
excel formula 3
Autonumber field in Excel that behaves the same as Access 0
Formula - If Statement with blank 4
Countif() formula 3
[CSE] SUM Array Formula with if condition 1
Joining Two formulas with the Help of AND / OR / IF Functions to getthe desired result 1
Macro to line up rows 1

Top