|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!