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: 2
Default Adding up the number of times a month is in a column

I have two colums, of which column B has months and dates. Sometimes the
date can be up to three times added, or not at all. I can't figure out a
formula to show me how many times Mar was added (12 in the below case) and
Apr was added (6 in the below case).

Number of update Date
1 1-Mar
2 1-Mar
3 1-Mar
4 2-Mar
5 2-Mar
6 2-Mar
7 3-Mar
8 3-Mar
9 3-Mar
10 4-Mar
11 4-Mar
12 4-Mar
13 1-Apr
14 1-Apr
15 1-Apr
16 2-Apr
17 2-Apr
18 2-Apr

Please help and thanks in advance!
 
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
adding up number of people present at certain times bamboozled Excel Worksheet Functions 4 September 18th 07 09:02 AM
Adding minutes in second column to times in first column Da Daniel Excel Worksheet Functions 2 August 24th 07 06:02 AM
counting the number of times something is bought during a month ldd Excel Worksheet Functions 1 November 22nd 05 07:18 PM
How to count the number of times something occurs within a certain month Joyce Excel Worksheet Functions 2 October 18th 05 08:38 PM
How to count the number of times something occurs within a certain month Joyce Excel Worksheet Functions 1 October 18th 05 06:11 PM


All times are GMT +1. The time now is 02:27 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"