Summing cells containing dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Laura - 09 May 2008 19:40 GMT

I need to add up the total number of cells in a column that contain entries.
THe entries are dates i..e,

Column A
March 3, 2008
Feb 2, 2008
Aprril 3, 2008

June 14, 2008
(sum should = 4 for the total number of cells with entries in the column)

Reply to this Message

akphidelt - 09 May 2008 19:52 GMT

use the formula Count

=Count(A1:A5)

> I need to add up the total number of cells in a column that contain entries.
> THe entries are dates i..e,
[quoted text clipped - 6 lines]
> June 14, 2008
> (sum should = 4 for the total number of cells with entries in the column)

Reply to this Message

T. Valko - 09 May 2008 19:56 GMT

Try this:

=COUNT(A1:A100)

Signature

Biff
Microsoft Excel MVP

>I need to add up the total number of cells in a column that contain
>entries.
[quoted text clipped - 7 lines]
> June 14, 2008
> (sum should = 4 for the total number of cells with entries in the column)

Reply to this Message

Otto Moehrbach - 09 May 2008 20:00 GMT

One way:
=CountA(A:A)
for all of column A. Otto

Reply to this Message

Mike H - 09 May 2008 20:05 GMT

Hi,

If your column contains numbers as well as dates then a function may help

Alt+F11 to open VB editot. Right click 'This Workbook' and insert module and
paste this in

Function datecount(rng As Range)
For Each c In rng
If IsDate(c) Then datecount = datecount + 1
Next
End Function

From the worksheet call with
=datecount(A:A)

Mike

Reply to this Message