Excel help (latest version)

Cromulent · 1 Aug 2019 at 04:35

I have a spreadsheet in Excel, which I use to account for my expenses. The duration of the costs may change, but they are all expenses. Let me give you an example. I have a list with Product, Amount and Duration. This is where I list all of the services I subscribe to.

The Duration could be Yearly, Monthly, Fortnightly or Weekly and I want to use the Duration column to work out how much I spend on each Duration, but I have no idea how to do it. Does anyone have any hints at all?

Thanks.

Cromulent · 1 Aug 2019 at 06:58

AHarvey said:
https://exceljet.net/excel-functions/excel-vlookup-function

On a seperate page use VLookup on the term "Yearly" and pull the details for cost and total them all

Oh, that looks cool. Thanks for the help.

Cromulent · 3 Aug 2019 at 08:18

Hmm. I've just had time to play around with this, and I can't seem to get it to sum all of the monthly elements in a table. I can get it to return a single value but not the same as the monthly expenses. Any help is appreciated.

Edit: Using this formula =VLOOKUP(B3,B3D :4,3,FALSE)

Edit 2: I had to add a space in the formula otherwise it turned it into a smiley annoyingly.

Edit 3: Fixed it by using SUMIF instead.

Cromulent · 12 Aug 2019 at 19:38

SourChipmunk said:
I would use a pivot table. Select your data, Insert > Pivot Table, then drag your Duration to Rows and your Amount to Values.

I haven't used a Pivot table before. I'll have to do some reading up on it. Thank you for your reply.