Product of multiple cells if the cell is greater than zero

[rcubed1971]

I am trying to generate a product of multiple cells (each cell is 2 cells merged into 1 larger cell) but only if the cell is greater than zero.

I cannot seem to generate a table to show what I am trying to accomplish and I cannot seem to insert a picture either.

Here is the formula that I am starting with

=PRODUCT(M15*M17*M19*M21*M23*M25*M27*M29)

(each of the M cells is a combination of 2 cells, example M15 is M15&M16 mergerd)

I need to find the product of the equation but only use the cell if that cell is greater than zero.

I hope this explains it well enough.

 

[MrTeeny]

Have you considered using a simple IF statement like

=IF(PRODUCT(M15*M17*M19*M21*M23*M25*M27*M29)>0,PRODUCT(M15*M17*M19*M21*M23*M25*M27*M29),"")

 

[MARZIOTULLIO]

	M​	N​	O​
15​	2​
16​			4320​
17​	3​
18​
19​	4​
20​
21​	5​
22​
23​	3​
24​
25​	2​
26​
27​	3​
28​
29​	2​
30​

<tbody>
</tbody>

o16=PRODUCT(IF(M15:N30>0,M15:N30)) control+shift+enter

 

[rcubed1971]

I did try that and it does not work because merged cells cannot be used in an array.

 

[rcubed1971]

I just tried this and it left my cell blank.

 

[MARZIOTULLIO]

Dropfile.to | Anonymous File Upload

look this file

 

[rcubed1971]

By the looks of your formula you created an array, is that correct? I cannot seem to create the array because of the merged cells. CTRL, SHIFT, Enter does not work. Is there another way?

Dropfile.to | Anonymous File Upload

look this file

 

[MARZIOTULLIO]

Can you provide some sample data and what the expected outcome is?

 

[Rick Rothstein]

By the looks of your formula you created an array, is that correct? I cannot seem to create the array because of the merged cells. CTRL, SHIFT, Enter does not work. Is there another way?

The formula in Message #3 works fine for me.