What formula can I use to get the sum of cells in 1 column, but only if that
cell corresponds to a date in January. For example, column A is the date
column and every cell has a different date in it and I want to get the sum of
all the entries in column T in January or February etc.


The date column is setup in the format of dd/mm/yy

I've tried
=SUMPRODUCT(--(A4:A100000/1/7),--(A1:A10000<0/2/7),--(AP4:AP10000))

and I've tried =SUMPRODUCT((JANUARY(A4:A10000)=1)*(AP4:AP10000))

but neither has worked. Help!

Hi

Try
=SUMPRODUCT(--(A4:A10000=--"01/01/07"),--(A1:A10000<=--"28/02/07"),--(AP4:AP10000))


--
Regards

Roger Govier


"judgejulz" wrote in message
...
What formula can I use to get the sum of cells in 1 column, but only
if that
cell corresponds to a date in January. For example, column A is the
date
column and every cell has a different date in it and I want to get the
sum of
all the entries in column T in January or February etc.


The date column is setup in the format of dd/mm/yy

I've tried
=SUMPRODUCT(--(A4:A100000/1/7),--(A1:A10000<0/2/7),--(AP4:AP10000))

and I've tried =SUMPRODUCT((JANUARY(A4:A10000)=1)*(AP4:AP10000))

but neither has worked. Help!

=SUMPRODUCT((MONTH(A4:A10000)=1)*(AP4:AP10000))

MONTH is a FUNCTION and tests if the month in A4:A10000 is 1 i.e January.

HTH

"judgejulz" wrote:

What formula can I use to get the sum of cells in 1 column, but only if that
cell corresponds to a date in January. For example, column A is the date
column and every cell has a different date in it and I want to get the sum of
all the entries in column T in January or February etc.


The date column is setup in the format of dd/mm/yy

I've tried
=SUMPRODUCT(--(A4:A100000/1/7),--(A1:A10000<0/2/7),--(AP4:AP10000))

and I've tried =SUMPRODUCT((JANUARY(A4:A10000)=1)*(AP4:AP10000))

but neither has worked. Help!

=SUMPRODUCT(--(A4:A10000=--"2007-01-01"),--(A4:A10000<--"2007-03-01"),--(AP4:AP10000))


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"judgejulz" wrote in message
...
What formula can I use to get the sum of cells in 1 column, but only if
that
cell corresponds to a date in January. For example, column A is the date
column and every cell has a different date in it and I want to get the sum
of
all the entries in column T in January or February etc.


The date column is setup in the format of dd/mm/yy

I've tried
=SUMPRODUCT(--(A4:A100000/1/7),--(A1:A10000<0/2/7),--(AP4:AP10000))

and I've tried =SUMPRODUCT((JANUARY(A4:A10000)=1)*(AP4:AP10000))

but neither has worked. Help!

That never worked either. It's just coming up 'error in formula' #VALUE!

"Roger Govier" wrote:

Hi

Try
=SUMPRODUCT(--(A4:A10000=--"01/01/07"),--(A1:A10000<=--"28/02/07"),--(AP4:AP10000))


--
Regards

Roger Govier


"judgejulz" wrote in message
...
What formula can I use to get the sum of cells in 1 column, but only
if that
cell corresponds to a date in January. For example, column A is the
date
column and every cell has a different date in it and I want to get the
sum of
all the entries in column T in January or February etc.


The date column is setup in the format of dd/mm/yy

I've tried
=SUMPRODUCT(--(A4:A100000/1/7),--(A1:A10000<0/2/7),--(AP4:AP10000))

and I've tried =SUMPRODUCT((JANUARY(A4:A10000)=1)*(AP4:AP10000))

but neither has worked. Help!