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]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

M​

[/TD]
[TD]

N​

[/TD]
[TD]

O​

[/TD]
[/TR]
[TR]
[TD]

15​

[/TD]
[TD]

2​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

16​

[/TD]
[TD][/TD]
[TD][/TD]
[TD]

4320​

[/TD]
[/TR]
[TR]
[TD]

17​

[/TD]
[TD]

3​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

18​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

19​

[/TD]
[TD]

4​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

20​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

21​

[/TD]
[TD]

5​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

22​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

23​

[/TD]
[TD]

3​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

24​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

25​

[/TD]
[TD]

2​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

26​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

27​

[/TD]
[TD]

3​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

28​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

29​

[/TD]
[TD]

2​

[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

30​

[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


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.