1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Formula to mulitiply all values in one column based on the criteria of another.

I'm looking for a formula that will mulitiply all values in one column based on the criteria of another. So on a data sheet; Column A contains text, Column B contrains a value.

Essentially I'm thinking like the SUMIF Formula, but instead of adding all the values, it multiplys all the values.

Thank you.

submitted by /u/HumanScar9638
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article