| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count the date
I have the folowing set up:
A B Delayed Redundancy 31/08/09 Delayed Redundancy 03/06/10 Employed Employed Delayed Redundancy 31/08/09 Employed I need a formula that will count how many Delayed redundancies there will be in 2009 Thank you for your help Toria |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count the date
Hi,
Try this =SUMPRODUCT((A1:A25="Delayed Redundancy")*(YEAR(B1:B25)=2009)) Mike "TORIA28" wrote: I have the folowing set up: A B Delayed Redundancy 31/08/09 Delayed Redundancy 03/06/10 Employed Employed Delayed Redundancy 31/08/09 Employed I need a formula that will count how many Delayed redundancies there will be in 2009 Thank you for your help Toria |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count the date
Assuming you have only text values in Col A..try the below
=SUMPRODUCT(--(A1:A100="Delayed Redundancy"),--(YEAR(B1:B100)=2009)) If this post helps click Yes --------------- Jacob Skaria "TORIA28" wrote: I have the folowing set up: A B Delayed Redundancy 31/08/09 Delayed Redundancy 03/06/10 Employed Employed Delayed Redundancy 31/08/09 Employed I need a formula that will count how many Delayed redundancies there will be in 2009 Thank you for your help Toria |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count the date
=SUMPRODUCT(($A$1:$A$100="Delayed Redundancy")*(YEAR($B$1:$B$100)
=2009)) On 22 Maj, 13:54, TORIA28 wrote: I have the folowing set up: * * * A * * * * * * * * * * * * * * * * * * * * * * *B Delayed Redundancy * * * * * * * * *31/08/09 Delayed Redundancy * * * * * * * * *03/06/10 Employed * * * * * * * * * Employed Delayed Redundancy * * * * * * * * *31/08/09 Employed * * * * * * I need a formula that will count how many Delayed redundancies there will be in 2009 Thank you for your help Toria |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count a value in a date range based on a date in another workshee. | Excel Worksheet Functions | |||
| How can I count a record if it contains a date within a date range | Excel Worksheet Functions | |||
| count the mean in few date but on de date it has various data | Excel Worksheet Functions | |||
| Count number of cells with date <today's date | New Users to Excel | |||
| count the number of cells with a date <= today's date | New Users to Excel | |||
Linear Mode
