How to exclude 0 from Product() ??

**tangomj** · 09-02-2012, 12:25 AM

A1=10
B1=0
C1=8
D1=0
E1=5

=Product(A1:E1)
= 400 ..and NOT 0

How can I exclude any 0's from the series and multiply with what ever cell value remains? Any one or combination of cells may be 0's at anytime. Need the product of all remaining values. Only when all the cells are 0 will the result be 0, otherwise a product result. Thx

**vlady** · 09-02-2012, 01:14 AM

hello try this one
if it's just ok for you--- array formula hit ctrl+shift+enter not just enter.

=PRODUCT(IF(A1:E1<>0,A1:E1))

**tangomj** · 09-02-2012, 01:37 AM

Yup, that worked! So simple. Thx

**vlady** · 09-02-2012, 02:04 AM

Your welcome.

regards,
vladimir

**Cutter** · 09-02-2012, 08:58 AM

@ tangomj

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.