Multiplication in Excel if cell contains greater than 0

[sgexcel321]

Hi, I am trying to multiply two cells if the cell is greater than 0.

Currently at the total price, I came up with a formula which I couldn't figure out how to make it work.

=IF(B13:V13>0, "B13:V13*B10:V10","")

Above is the formula that I am trying.
So for example, if items 1 - 21 is all of different price. The cell that contains 1 in each row will multiply with the correct price above.

I can do manually by doing the formula
=(B13*B10)+(C13*C10)+(D13*D10) and so on.....
But I just want to learn if there is a formula to firstly, check if the cell is greater than 0 and then multiply if its greater than 0.
After that having a total sum at the end in the Total Price cell.

Anyone can help?

 

[Fluff]

Hi & welcome to MrExcel.
Why do you need to check if there is a number in B13:V13, you can just use

=SUMPRODUCT($B$10:$V$10,B13:V13)

 

[sgexcel321]

Hi & welcome to MrExcel.
Why do you need to check if there is a number in B13:V13, you can just use

=SUMPRODUCT($B$10:$V$10,B13:V13)

Hi, I don't want to just copy and paste your formula and then its done and thanks by the way it worked perfectly.

May I ask where is the multiplication process in the formula?

Why is the cells fixed in the first requirements? $B$10:$V$10.

Just hope to learn something

 

[Fluff]

The 1st range is locked, with the 2nd one relative, so that you can just drag the formula down the column, rather than typing it in for every row.

May I ask where is the multiplication process in the formula?

It's what the function does.

 

[sgexcel321]

The 1st range is locked, with the 2nd one relative, so that you can just drag the formula down the column, rather than typing it in for every row.

It's what the function does.

Ah thanks. Learnt something new today

 

[Fluff]

You're welcome & thanks for the feedback.