Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Question
Can anyone tell me how to count the following. I have a list containing
date, description and type. I need to count all of the fields containg "Type A" starting on the 05/06/06 and finishing a week later. How do i put this into a formula. Thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Question
Say your Date/Description/Type array is in A2:C23
Say wanted start date is in E2, wanted type in F2. To count matching entries, enter: =SUMPRODUCT((A2:A22=E2)*(A2:A22<=E2+7)*(C2:C22=F2 )) See example: http://cjoint.com/?gcnviozPkd HTH -- AP "ingalla" a écrit dans le message de news: ... Can anyone tell me how to count the following. I have a list containing date, description and type. I need to count all of the fields containg "Type A" starting on the 05/06/06 and finishing a week later. How do i put this into a formula. Thanks in advance |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting Question
Ardus
Thanks very much for your help, it works a treat. Can you, or anyone else, tell me one thing. As this data is going to be constantly expanding, how can i include in your formula, a way of setting the cell, that is now A22 in your formula, to the last cell of the data using the formulas? I need A22 to update to the last cell of data in the column each time the workbook is opened and updated? Thanks Andy "Ardus Petus" wrote: Say your Date/Description/Type array is in A2:C23 Say wanted start date is in E2, wanted type in F2. To count matching entries, enter: =SUMPRODUCT((A2:A22=E2)*(A2:A22<=E2+7)*(C2:C22=F2 )) See example: http://cjoint.com/?gcnviozPkd HTH -- AP "ingalla" a écrit dans le message de news: ... Can anyone tell me how to count the following. I have a list containing date, description and type. I need to count all of the fields containg "Type A" starting on the 05/06/06 and finishing a week later. How do i put this into a formula. Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Question | Excel Discussion (Misc queries) | |||
Counting rows of blanks across certain columns | New Users to Excel | |||
Counting and Summing | Excel Discussion (Misc queries) | |||
Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
Counting question | Excel Discussion (Misc queries) |