I want to display the sum of my monthly expenditure...

  • Thread starter Thread starter chrisjleu
  • Start date Start date
C

chrisjleu

I have a date column and an expense column, so all my expenses on
particular day are recorded.

On another sheet, i want to display a list of months and have the su
of my expenses for each month in the adjacent cell.

Sounds simple enough right. I thought of using the MONTH functio
somehow but its useless, ican't get it to work. Even after reading th
manual i can't understand it.

Can anyone tell me the way to do this.

Date Expenditure
26-Apr-2004 20
26-Apr-2004 34
26-Apr-2004 12
26-Apr-2004 32
02-May-2004 11
04-May-2004 53
04-May-200411
04-May-2004 11
05-May-2004 23
05-May-2004 24

The problem I have I think is getting excel to extract the month fro
the 'date' column
 
Hi
try
=SUMPRODUCT(--(MONTH(A1:A100)=1),--(YEAR(A1:A100)=2004),B1:B100)
For January 2004
 
It's not useless, here;


=SUM(IF(MONTH(A1:A100)=1,B1:B100))

entered with CTRL SHIFT ENTER.

month 1 = jan, month = feb, etc.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I sum expense values depending on the month 2
Month (MMM) from date (dd/mmm/yy) 1
Help on Pivot Table 2
Accumulate Amortized Expenditures by month 2
Need to transform the dates to months 4
help to count easily 2
count no. of dates in a column that falls on certain month & year 2
When building a chart Dates are been included that are not in thedate range 1

Back
Top