ExcelBanter - Count Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Count Function (https://www.excelbanter.com/excel-worksheet-functions/195046-count-function.html)

Astro

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.

Bob Phillips

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.

Gary''s Student

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.

All times are GMT +1. The time now is 08:13 PM.