Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing cells containing dates
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) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing cells containing dates
use the formula Count
=Count(A1:A5) "Laura" wrote: 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) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing cells containing dates
Try this:
=COUNT(A1:A100) -- Biff Microsoft Excel MVP "Laura" wrote in message ... 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) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing cells containing dates
One way:
=CountA(A:A) for all of column A. Otto "Laura" wrote in message ... 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) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing cells containing dates
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 "Laura" wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
problem summing columns with dates | Excel Worksheet Functions | |||
Summing between 2 dates | Excel Worksheet Functions | |||
Summing values b/t two dates | Excel Discussion (Misc queries) | |||
Summing weekending dates | Excel Worksheet Functions | |||
Summing moving ranges & dates | Excel Worksheet Functions |