M3G4L0D0N
New member
- Joined
- Oct 18, 2012
- Messages
- 3
- Reaction score
- 0
- Points
- 0
Hi everyone,
I have two sheets that look like:
Sheet1
Sheet2
I'm trying to make cells B2 to B4 return the total of each category (B2+B5 in sheet1 = B2 in sheet2, in the example above).
Since the list is very large and will continue growing, I need to find a way to automate this calculation.
The way I've tried to approach this is:
Based on SUMIF( range, criteria, [sum_range] )
I'm trying =SUMIF((Sheet1 column C), (Food), B:B)
where "Food" is a name defined for each category, but I don't know how I could match automatically cells B2 and B5 to C2 and C5.
I simply need Excel to find and sum all of the expenses within a category, in a selected month.
Any help or alternative ideas will be greatly appreciated.
Thanks.
I have two sheets that look like:
Sheet1
A | B | C | |
1 | Date | Amount | Category |
2 | 18/10/12 | € 15,00 | Food |
3 | 19/10/12 | € 40,00 | Car |
4 | 19/10/12 | € 15,00 | Tools |
5 | 20/10/12 | € 5,00 | Food |
Sheet2
A | B | C | |
1 | Month | Amount | Category |
2 | Oct-12 | € 20,00 | Food |
3 | Oct-12 | € 40,00 | Car |
4 | Oct-12 | € 15,00 | Tools |
I'm trying to make cells B2 to B4 return the total of each category (B2+B5 in sheet1 = B2 in sheet2, in the example above).
Since the list is very large and will continue growing, I need to find a way to automate this calculation.
The way I've tried to approach this is:
Based on SUMIF( range, criteria, [sum_range] )
I'm trying =SUMIF((Sheet1 column C), (Food), B:B)
where "Food" is a name defined for each category, but I don't know how I could match automatically cells B2 and B5 to C2 and C5.
I simply need Excel to find and sum all of the expenses within a category, in a selected month.
Any help or alternative ideas will be greatly appreciated.
Thanks.