Database problem
 

I have set up a spread sheet to keep a track of my spending. Column A is
formatted to dd/mm/yyyy and columns B, C, D, E, & F are my expenses with
column G being income and column H being the balance.
I am trying to set up a seperate worksheet where a single cell will give me
the total spending based upon a calendar month.
Many thanks in advance for all those who have helped.

Database problem
 

hi
i have a similar database. here is the formula i use..
=SUMPRODUCT((MONTH(B$3:B500)=7)*(E$3:E500))
in my db, column B is the month and column E is expenses.
you will need a fomula like above for each months.
you can sum the months for year total.
jan = 1, feb = 2, etc.

regards
FSt1

"Mark" wrote:

I have set up a spread sheet to keep a track of my spending. Column A is
formatted to dd/mm/yyyy and columns B, C, D, E, & F are my expenses with
column G being income and column H being the balance.
I am trying to set up a seperate worksheet where a single cell will give me
the total spending based upon a calendar month.
Many thanks in advance for all those who have helped.

Database problem
 

Hi
What would I need to add into the formula seperate by month and year as my
db starts April 07 thru to December 2010?
Thank you.

"FSt1" wrote:

hi
i have a similar database. here is the formula i use..
=SUMPRODUCT((MONTH(B$3:B500)=7)*(E$3:E500))
in my db, column B is the month and column E is expenses.
you will need a fomula like above for each months.
you can sum the months for year total.
jan = 1, feb = 2, etc.

regards
FSt1

"Mark" wrote:

I have set up a spread sheet to keep a track of my spending. Column A is
formatted to dd/mm/yyyy and columns B, C, D, E, & F are my expenses with
column G being income and column H being the balance.
I am trying to set up a seperate worksheet where a single cell will give me
the total spending based upon a calendar month.
Many thanks in advance for all those who have helped.