Hello to all, first post!!

[alexpowers]

Hi, I'm pulling my hair out in my office because I can't figure a problem out in excel, what I've got is 4 cells with numerical values in and I want to multiply then togther so say (A1)*(B1)*(C1)*(D1) , that works fine until one of the cells contains a zero, the whole calc stops I understand why it happens but is there a way that zero cell can be ignored? tried IF statement but seemed to many computations!!! to be honest I'm stuck
If anyone could help that would be great.

 

[JamesW]

edit: Wrong formula, give me a sec!

Here we go (welcome to the board btw!):

=PRODUCT(IF(A1:D1>0,A1:D1))

Confirmed with CTRL, SHIFT and ENTER - not just enter.

 

[jeffreybrown]

Hello and Welcome to the Board,

How about...

=SUMIF(A1:D1,">0")

 

[j_latendre]

Try:

=IF(A1=0,1,A1)*IF(B1=0,1,B1)*IF(C1=0,1,C1)*IF(D1=0,1,D1)

Jesse

 

[alexpowers]

Cant belive I've been pulling my hair out when I should have just asked!!!!!,
All work great, much appreciated for the super fast response's
thanks a lot .

 

[JamesW]

Hi Jeffery,

=SUMIF(A1:D1,">0") will add the values, not multiply them.

Alex,

Glad you got it working.

 

[Boller]

This might help to resolve some of your problem :-

http://www.youtube.com/watch?v=NaBovRJxyQ4

 

[jeffreybrown]

Yes I see now, thanks James