Counting Instances of a line of text? [Excel 2003]

[Maillme]

Hi there,

I have a column which has a drop down with the following options available:

Over Due
Not Due

I would like to be able to report (possibly in my footer) on the number of instances of each, for example:

23 Overdue
67 Not Due

Any help on the needed formula is greatly appreciated,

thanks,
Neil

 

[GlennUK]

Look at the COUNTIF function for this.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[Maillme]

COUNT IF works great - however,

How do i defin ean ever expanding range?

E.g. i have 200 rows just now, but tommorow i might have 210.

thanks again,
Neil

 

[Maillme]

oh also - how would i get my cell values into my footer?

thanks,
Neil

 

[Maillme]

I used this code to get this in my footer, but unfortunatelly, it only prints my header / footer info, and puts the cell value on the top celft of the page (not the centre footer as expected):

Private Sub Workbook_BeforePrint(Cancel As Boolean)
With Worksheets("CRP ARIAD Log").PageSetup
.CenterFooter = Worksheets("CRP ARIAD Log").Range("O2")
End With
End Sub

Neil

 

[SkipVought]

Hi,

"How do i defin ean ever expanding range?"

check out faq68-1331



Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}