Formula needed
 

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.

Formula needed
 

try:

=SUMPRODUCT((MONTH(A1:A)=1)*(T1:T100))

assuming there only one year i.e one set oj 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.

Formula needed
 

=SUMPRODUCT(--(A1:A1039082),--(A1:A10<39114),--(T1:T10))

extend this if you have moe or less than 10 rows.
--
Gary's Student
gsnu200707


"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.

Formula needed
 

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!

"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.

Formula needed
 

=SUMPRODUCT((MONTH(A1:A)=1)*(T1:T100))

MONTH is a function so from your posting:


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

HTH


"Toppers" wrote:

try:

=SUMPRODUCT((MONTH(A1:A)=1)*(T1:T100))

assuming there only one year i.e one set oj 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.