Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Counting data for month and year

I've looked at the multiple threads and can't seem to figure out how to count
the number of cells that have values within a date range. For example, how
many cells in A2:A76 have a value within July 08? I have found how to do it
for the month but how about the year?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default Counting data for month and year

=COUNTIF(A2:A76,"<"&DATEVALUE("8/1/2008"))-COUNTIF(A2:A76,"<"&DATEVALUE("7/1/2008"))

--
Gary''s Student - gsnu200798
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Counting data for month and year

Thanks! I made one slight change--< to in <"&DATEVALUE("7/1/2008").

Any idea how I can autofill this formula without too much maintenance.

Thanks again!


"Gary''s Student" wrote:

=COUNTIF(A2:A76,"<"&DATEVALUE("8/1/2008"))-COUNTIF(A2:A76,"<"&DATEVALUE("7/1/2008"))

--
Gary''s Student - gsnu200798

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Counting data for month and year

Well, you're entitled to make that change if you like, as it was your
question, but perhaps you could explain the logic of your revised formula?
You may also wish to recheck the test results for your revised version, as
Gary''s Student's formula looks to be the correct answer.
--
David Biddulph

"ahkasiv" wrote in message
...
Thanks! I made one slight change--< to in <"&DATEVALUE("7/1/2008").

Any idea how I can autofill this formula without too much maintenance.

Thanks again!


"Gary''s Student" wrote:

=COUNTIF(A2:A76,"<"&DATEVALUE("8/1/2008"))-COUNTIF(A2:A76,"<"&DATEVALUE("7/1/2008"))

--
Gary''s Student - gsnu200798




Reply
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
Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? misscrf Excel Discussion (Misc queries) 1 December 14th 07 03:59 PM
Get Data based on Month and Year karstens Excel Worksheet Functions 1 August 2nd 06 12:42 AM
Counting distinct entries based on meeting month & year criteria jennifer Excel Worksheet Functions 3 February 9th 06 02:56 PM
Counting Entries by Month and Year ImaGina Excel Worksheet Functions 1 January 5th 06 07:11 AM
counting date entries by month & year Di Excel Worksheet Functions 7 August 24th 05 08:39 PM


All times are GMT +1. The time now is 10:13 AM.

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

About Us

"It's about Microsoft Excel"