Help with formulas

[joakimh]

Dear all!
I need help with some formulas.

See attached picture below

Orange area (Rows A-D) contains an export from my bank with all payments I have done.
Row E will be categories which I will make myself.

Yellow area (row H and I) will be total amount of each category during the year..
This one works using following formula: =SUM.IF(E2:E50; H2&"*"; D2:D50)

But the last green area (Row K-V) is my problem.
I made an exemple how I would like to have it, but I need help with formulas.

Here I would to take the total montly amount of each category and month and place it in each month.
I guess I need to do some SUMIF as well, but I cant get it to work?!

Please help

 

[joakimh]

Check post #6 I already did that...

Check that and revert...

strange, cant get it to work in my excel. could you upload your testfile so I could download and test your?

 

[SanjayGMusafir]

strange, cant get it to work in my excel. could you upload your testfile so I could download and test your?

Interestingly never needed that. Unable to find a way to upload my test file...

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Sum of amount based on categories
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Fluff]

is it becuase of a swedish Excel version?

Try changing the commas to semi-colons, also do you use a Swedish Language version?

 

[Fluff]

Unable to find a way to upload my test file...

You cannot upload files, you would need to use a share site.

 

[joakimh]

Check post #6 I already did that...

Check that and revert...

Somehow it didnt work changing formula to semicolon.
Instead I did a change in Excel and chnge from semicolon which Sweden use to semicolon and then it worked :S

Bug or something?! Anyway it looks good now and working fine

Next step will be to build some nice graphs :D

 

[joakimh]

You cannot upload files, you would need to use a share site.

so

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Sum of amount based on categories
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

sorry for this, will not happend again

 

[SanjayGMusafir]

Anyway it looks good now and working fine

Glad it worked for you. Thanks for the feedback