| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count Function
I would like to use excel to count the number of cells containing year 2008.
23-Apr-07 15-May-08 21-Jan-08 05-Feb-07 Please advice on the function to do this. Thank you. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Function
=SUMPRODUCT(--(YEAR(A2:A20)=2008))
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Astro" wrote in message ... I would like to use excel to count the number of cells containing year 2008. 23-Apr-07 15-May-08 21-Jan-08 05-Feb-07 Please advice on the function to do this. Thank you. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count Function
With data in A1 thru A100:
=COUNTIF(A1:A100,"<39814")-COUNTIF(A1:A100,"<39448") -- Gary''s Student - gsnu200795 "Astro" wrote: I would like to use excel to count the number of cells containing year 2008. 23-Apr-07 15-May-08 21-Jan-08 05-Feb-07 Please advice on the function to do this. Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count IF Function | Excel Worksheet Functions | |||
| function to use to count value | Excel Worksheet Functions | |||
| i think i need count function help | Excel Worksheet Functions | |||
| Count Function | Excel Worksheet Functions | |||
| Count function | Excel Worksheet Functions | |||
Hybrid Mode
