help calculated total for each month
 

i am trying to calulate the total intake for each month
ie january = 10
february = 6
march = 10

column a column b
date intake
01/01/09 10
01/03/09 2
11/02/09 6
12/03/09 7
12/03/09 1

please help

help calculated total for each month
 

The below will return the sum for the month of May

=SUM(IF(MONTH(A2:A100)=5,B2:B100))

Suppose in C2 you have date entered formated to display January, the below
should return the total for January
=SUM(IF(MONTH(A2:A100)=Month(c2),B2:B100))

If this post helps click Yes
---------------
Jacob Skaria


"jengy1" wrote:

i am trying to calulate the total intake for each month
ie january = 10
february = 6
march = 10

column a column b
date intake
01/01/09 10
01/03/09 2
11/02/09 6
12/03/09 7
12/03/09 1

please help

help calculated total for each month
 

Oops, please ignore the previous post

C1 = date
=SUMPRODUCT(--(MONTH(A2:A10)=MONTH(C2)),--(B2:B10))


If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

The below will return the sum for the month of May

=SUM(IF(MONTH(A2:A100)=5,B2:B100))

Suppose in C2 you have date entered formated to display January, the below
should return the total for January
=SUM(IF(MONTH(A2:A100)=Month(c2),B2:B100))

If this post helps click Yes
---------------
Jacob Skaria


"jengy1" wrote:

i am trying to calulate the total intake for each month
ie january = 10
february = 6
march = 10

column a column b
date intake
01/01/09 10
01/03/09 2
11/02/09 6
12/03/09 7
12/03/09 1

please help

help calculated total for each month
 

=SUMPRODUCT(--(MONTH($E$11:$E$21)="1"*(F11:F21)))


"1" = January, adjust your range as need

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"jengy1" escreveu:

i am trying to calulate the total intake for each month
ie january = 10
february = 6
march = 10

column a column b
date intake
01/01/09 10
01/03/09 2
11/02/09 6
12/03/09 7
12/03/09 1

please help

help calculated total for each month
 

Jacob, the previous formula runs, as an array, he should enter with
Ctrl+Shif+enter, not just enter

chers
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Jacob Skaria" escreveu:

Oops, please ignore the previous post

C1 = date
=SUMPRODUCT(--(MONTH(A2:A10)=MONTH(C2)),--(B2:B10))


If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

The below will return the sum for the month of May

=SUM(IF(MONTH(A2:A100)=5,B2:B100))

Suppose in C2 you have date entered formated to display January, the below
should return the total for January
=SUM(IF(MONTH(A2:A100)=Month(c2),B2:B100))

If this post helps click Yes
---------------
Jacob Skaria


"jengy1" wrote:

i am trying to calulate the total intake for each month
ie january = 10
february = 6
march = 10

column a column b
date intake
01/01/09 10
01/03/09 2
11/02/09 6
12/03/09 7
12/03/09 1

please help