Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
Get Data based on Month and Year | Excel Worksheet Functions | |||
Counting distinct entries based on meeting month & year criteria | Excel Worksheet Functions | |||
Counting Entries by Month and Year | Excel Worksheet Functions | |||
counting date entries by month & year | Excel Worksheet Functions |