Forum Discussion
Formula for finding product of factors.
I am looking for a formula to calculate the product of cells a1, b2 and c3. The formula should only calculate the cells with value greater than 0. If a cell is 0, it must not be included in the calcu...
MaKo3060 The cells are on a diagonal of a 3x3 matrix, Assuming all other cells are empty, you could try this:
If this doesn't work for you, please clarify and show us how your data is set-up.