Excel Help - ledgers & IF's.

November 27, 2011 at 10:37:19
Specs: Windows Vista
I have a spreadsheet that I use as an account ledger. Column D is the amount spent. I use column F as a category (i.e.-"business").

In a separate spreadsheet, I list all items from a specific category. Is there a way that my second sheet can scan my first sheet and only pull in amounts from this "business" category? Specifically, if it found a "business" transaction, it would list the amount spent from column D.

I thought I was getting to this at one point, but it only would list the first "business" transaction. This was a while ago, though, and I don't remember the formula I used anymore.

Thanks in advance!


See More: Excel Help - ledgers & IFs.

Report •

November 27, 2011 at 18:36:59
Read up on Advanced Filters in the Excel Help files, especially the section on using Criteria.

Let us know if that works for you.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question