Forum Discussion

MelStewart9655's avatar
MelStewart9655
Copper Contributor
Aug 21, 2020

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's avatar
MelStewart9655
Copper Contributor
Aug 24, 2020

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. 

wumolad's avatar
wumolad
Iron Contributor
Aug 24, 2020

MelStewart9655 

 

I think you can still use the sheet. Just filter out those items with zero. Select all the items and then click on Data >>Filter. Then click on column K header to uncheck zero:

 

 

and click ok.

 

Then click on Ctrl + G, click on special and select visible cells only:

 

 

 

This allows you to copy only the copied items which you can then paste to another sheet.

 

I have attached a sample for you.

 

Hope this helps.

 

Cheers

  • MelStewart9655's avatar
    MelStewart9655
    Copper Contributor
    Aug 24, 2020

    thank you for your advice!  I appreciate it! wumolad 

Resources