Home |
Search |
Today's Posts |
#1
|
|||
|
|||
countif and date formats
Hi
I have a list of dates (in 12/12/2004 format) in a column. I need to seach how many dates are in the list with a year of 2004, regardless of day or month. I was using the countif function (=countif(a2:z2,"=2004") but it does not recognize any cells since there are months and days attached in the list. I also cannot change the list to show just years either.... I hope that this makes sense, and thanks for any help Last edited by shnim1 : November 9th 06 at 09:29 PM |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
countif and date formats
Column or Row?
=sumproduct(--(YEAR(A2:Z2)=2004)) Adjust the ranges to match--but you can't use whole columns. =sumproduct() likes to work with numbers. The -- stuff changes trues and falses to 1's and 0's. Bob Phillips explains =sumproduct() in much more detail he http://www.xldynamic.com/source/xld.SUMPRODUCT.html And J.E. McGimpsey has some notes at: http://mcgimpsey.com/excel/formulae/doubleneg.html shnim1 wrote: Hi I have a list of dates (in 12/12/2004 format) in a column. I need to seach how many dates are in the list with a year of 2004, regardless of day or month. I was using the countif function (=countif(a2:z2,"=2004") but it does not recognize any cells since there are months and days attached in the list. I also cannot change the list to show just years either.... I hope that this makes sense, and thanks for any help -- shnim1 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel today countif over expired date | Excel Worksheet Functions | |||
Countif and date check for second criteria | Excel Worksheet Functions | |||
Countif and date check for second criteria | Excel Worksheet Functions | |||
COUNTIF criteria using date ranges? | Excel Worksheet Functions | |||
use a date range as criteria in a countif formula | Excel Worksheet Functions |