LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default summing the number of dates

The scenario:
cell A - I have a range of date (title Date) and cell B - I have a range of
incidents (title Error Dept)
-------
Date | Error Dept
Feb 12 D
Feb 12 O
Feb 13 D
Feb 15 O
Feb 12 D
Feb 13 O

How can I formula the results that tells me there are 2 Ds in Feb 12 from
Error Department.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Summing between two dates Don Excel Worksheet Functions 6 July 29th 08 03:10 PM
Summing cells containing dates Laura Excel Worksheet Functions 4 May 9th 08 08:05 PM
Summing between 2 dates Ken[_2_] Excel Worksheet Functions 2 September 6th 07 10:31 PM
Summing values b/t two dates starguy Excel Discussion (Misc queries) 3 April 26th 06 07:39 AM
Summing weekending dates Jim Excel Worksheet Functions 1 January 17th 06 02:42 AM


All times are GMT +1. The time now is 10:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"