Forum Discussion
Solved
Multiply cells but ignore zeros and blanks cells
How do I multiple numbers in different cells BUT ignore blanks and zeros. (Please not this a long excel sheet). I want to multiple all the numbers from cell A1:H1 and put the answer in cell J in tota...
Excelstudent If you are on a recent Excel version or on-line, this will work.
Or perhaps better to use:
=PRODUCT(FILTER(A2:H2,A2:H2<>0))Then you capture everything except zeros and blanks.
Excelstudent If you are on a recent Excel version or on-line, this will work.
Or perhaps better to use:
=PRODUCT(FILTER(A2:H2,A2:H2<>0))
Then you capture everything except zeros and blanks.
Thank you very much for your help. This worked wonderfully.