Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count function
Okay, continuing to work this count function problem and have hit a brick
wall with it. What I am trying to do is count the number of occurrences each month when a new procedure was created. Below I created a quick example. Column A would have the date, and column B would then have an 'x' in it if a new procedure was created. Need to create a count calculation to return the number of new procedures each month. Not sure how to accomplish that. A B 1/1/09 X 1/5/09 1/10/09 X 2/1/09 X 3/5/09 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count function
Hi,
Put this in a cell and drag down 11 rows to get the sum for each month =SUMPRODUCT((MONTH($A$1:$A$20)=ROW(A1))*($B$1:$B$2 0="x")) Mike "John Peterson" wrote: Okay, continuing to work this count function problem and have hit a brick wall with it. What I am trying to do is count the number of occurrences each month when a new procedure was created. Below I created a quick example. Column A would have the date, and column B would then have an 'x' in it if a new procedure was created. Need to create a count calculation to return the number of new procedures each month. Not sure how to accomplish that. A B 1/1/09 X 1/5/09 1/10/09 X 2/1/09 X 3/5/09 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count function
Try
=SUMPRODUCT(--(MONTH($A$1:$A$5)=1)*($B$1:$B$5="X")) will give you Jan =SUMPRODUCT(--(MONTH($A$1:$A$5)=2)*($B$1:$B$5="X")) will give you Feb etc "John Peterson" wrote: Okay, continuing to work this count function problem and have hit a brick wall with it. What I am trying to do is count the number of occurrences each month when a new procedure was created. Below I created a quick example. Column A would have the date, and column B would then have an 'x' in it if a new procedure was created. Need to create a count calculation to return the number of new procedures each month. Not sure how to accomplish that. A B 1/1/09 X 1/5/09 1/10/09 X 2/1/09 X 3/5/09 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another which count function? | Excel Worksheet Functions | |||
COUNT Function | New Users to Excel | |||
Count function | Excel Discussion (Misc queries) | |||
which count function? | Excel Discussion (Misc queries) | |||
count function | Excel Discussion (Misc queries) |