Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculated Field Total in Pivot Table | Excel Discussion (Misc queries) | |||
Calculated Field Total formula not working | Excel Worksheet Functions | |||
Using '% of Total' in calculated field in Pivot Table | Excel Discussion (Misc queries) | |||
Calculated Pivot table field on YTD £(subract Mar-feb)=month | Excel Worksheet Functions | |||
How do I calculated total hours per week | Excel Worksheet Functions |