Sums between dates

N

NumbersDevon

Hi
I have a spreadsheet with this strucure and I want to fill cells that have
sums of the entries in each year

A B
20/09/08 100
31/08/08 200
15/09/08 150

need a cell with the total of all values in column B in the month of 09/08
then 08/08 etc

total would be 250

Please help
 
B

Bernard Liengme

=SUMPRODUCT((Year(A1:A100)=2008)*((MONTH(A1:A100)=8)+(MONTH(A1:A100)=9))*B1:B100
best wishes
 
M

Mike H

Hi

Put this in a cell and drag down to get the sum of each month in 2008

=SUMPRODUCT((MONTH($A$1:$A$10)=ROW(A1))*(YEAR($A$1:$A$10)=2008)*($B$1:$B$10))

Mike
 
P

Pete_UK

You could do it this way:

=SUMPRODUCT(--(TEXT(A$1:A$10,"mmm-yy")="Sep-08"),B$1:B$10)

Adjust the ranges to suit. For August just change "Sep-08" to
"Aug-08".

Hope this helps.

Pete
 

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

Top