Search code examples
excelexcel-formulaexcel-2010vba7

Multiplying column and skipping blanks

I need to multiply column and it has to skip blank range, I need formula or VBA for this case. For example, if Range A1 having value 2, range C1 = 3, range E1 is blank, range G1 = 1, Range I1 = 3 & K1 is blank, the answer is 2 ×3 ×1 ×3 = 18. I just need a solution to ignore columns having blank value either formula or VBA code

I tried to multiply from range A1×C1×E1×G1×I1×K1, I got answer as 0 since it is considering blank column as 0.

Solution

  • I have got the solution for this case, =Product is the perfect formula