View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default sumif, countif, datedif formula

The below will return the number of entries of year 2007.

=SUMPRODUCT(--(YEAR(K3:K1408)=2007))

If this post helps click Yes
---------------
Jacob Skaria


"v1rt8" wrote:

K3:K1408 contain dates of hire i.e. 4/30/2007
would like to count how many were hired in year 2007, 1999, etc.. how what
would be the formula, is it a nested formula? at a loss. really do not want
to make a separate column just to provide the year then do a countif column.
thanks for help