Excel help (latest version)

Cromulent

Cromulent

Cromulent

Soldato
Joined
1 Nov 2007
Posts
7,043
Location
England
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.
 
While VLookUp and HLookUp are powerful (although for more complicated things, Offset and Match are even more powerful), I think in the OP's case, SUMIF should do the job.
More recent versions of Excel also have a SUMIFS for use with multiple criteria's.
 
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.
 
Last edited:
You must log in or register to reply here.
Back
Top Bottom