Excel Vlookup

I have an excel with several sheets.

One sheet one, I have all my entries for expenses, with expenses.

On a seperate sheet, I have a totals sheet. I need somebody to use vlookup or whatever else you need, to find all the expenses in that category and add them up.

I also need them to be able to tell by date (ie, 4 quarters of the year).

One more thing is, if I do a filter on the first sheet, ie and remove some of the rows, I want the totals sheet to be able to cater for it (shouldnt be a problem I dont think).

I have used vlookup before, and I vaguely remember, but not worth me going over hours to learn again.

Let me know if something is not clear.

Leave a Reply

Your email address will not be published. Required fields are marked *