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 ...
Hi wumolad
Please see attached my excel spreadsheet. I use this to import COGS using this sheet. I basically don't want a large list of companies that have 0 amount, as this will be part of the journal entry to be imported. So if I am able to somehow exclude companies with a 0 amount, it will be much cleaner.
MelStewart9655 , In attached file, i used your already made sheet as a temporary calculation, and out of it, filtered out only the non-zero companies as you desire. It gets filtered automatically. Only take care to drag down the formulas enough so that the formula region is more down below the data region.
this is a great idea! thank you! amit_bhola