Forum Discussion
Formula to sum and exclude
Hi, I am trying to create a formula that will look up customer name and amount from one sheet and match it the customer name on a different sheet. I would like it to also not include customers that ...
MelStewart9655 , it would be better if you attach a file with example data. Reading your question, it creates a doubt about intent and aim, since, you are trying to achieve a sum and want to exclude 0 (zeroes), so how the result of sum would get affected whether or not zeroes are included? Obviously, we're not able to understand the query, for which, an attachment with example data (and probably a typed, manually formulated result that you expect) would help!