I am building a household budget using Excel.
On my raw data sheet, Column A contains the name of each kind of expenditure (“General Household,” “Subscriptions,” etc.); Column B contains the month; Column C contains the amount. So, for example
General Household – January – 100
General Household – January – 50
General Household – February – 85
General Household – February – 25
Subscriptions – January – 35
Subscriptions – January – 45
Subscriptions – February – 25
Subscriptions – February – 15
I’m looking for a formula for another sheet that would pull the sum of each kind of expenditure for a given month. So, in January, I want a formula that looks down Column A for all General Household expenditures, then provides the sum of those incurred in that month. So, for January, 100 + 50 = 150; for February, 85 + 25 = 110. And likewise for Subscriptions. For January, 35 + 45 = 80; for February, 25 + 15 = 40. And so on.
Can anyone help me devise such a formula, or point to a pertinent tutorial?
Much appreciated!
On my raw data sheet, Column A contains the name of each kind of expenditure (“General Household,” “Subscriptions,” etc.); Column B contains the month; Column C contains the amount. So, for example
General Household – January – 100
General Household – January – 50
General Household – February – 85
General Household – February – 25
Subscriptions – January – 35
Subscriptions – January – 45
Subscriptions – February – 25
Subscriptions – February – 15
I’m looking for a formula for another sheet that would pull the sum of each kind of expenditure for a given month. So, in January, I want a formula that looks down Column A for all General Household expenditures, then provides the sum of those incurred in that month. So, for January, 100 + 50 = 150; for February, 85 + 25 = 110. And likewise for Subscriptions. For January, 35 + 45 = 80; for February, 25 + 15 = 40. And so on.
Can anyone help me devise such a formula, or point to a pertinent tutorial?
Much appreciated!