| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count the number of items received in a certain month
I am trying to get my excel sheet to count the number items received in a
certain month. For example 02/Mar/09 59 04/Apr/09 62 01/Mar/9 25 01/May/09 25 I there want the total number of items received in March adding togther in a cell, then in next cell totl number recived in April and so on. Any help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count the number of items received in a certain month
Assuming you have dates in ColA and values in ColB use the below formula
Sum of March =SUMPRODUCT(--(MONTH($A$1:$A$1000)=3),--($B$1:$B$1000)) Sum of April =SUMPRODUCT(--(MONTH($A$1:$A$1000)=4),--($B$1:$B$1000)) If this post helps click Yes --------------- Jacob Skaria "Steven" wrote: I am trying to get my excel sheet to count the number items received in a certain month. For example 02/Mar/09 59 04/Apr/09 62 01/Mar/9 25 01/May/09 25 I there want the total number of items received in March adding togther in a cell, then in next cell totl number recived in April and so on. Any help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count the number of items that meet 2 criteria? | Excel Worksheet Functions | |||
| Formula to count month-specific items | Excel Discussion (Misc queries) | |||
| Count number of items in one column that have a value in another? | Excel Worksheet Functions | |||
| Count number of items by month | Excel Worksheet Functions | |||
| count number of items in a row? help *file included* | Excel Worksheet Functions | |||
Linear Mode
