sumif, countif, datedif formula

  • Thread starter Thread starter v1rt8
  • Start date Start date
V

v1rt8

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
 
The below will return the number of entries of year 2007.

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

If this post helps click Yes
 
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
Click to expand...

You can use COUNTIF also:

For 2007, something like:

=COUNTIF(K3:K1408,">="&DATE(2007,1,1)) - COUNTIF(K3:K1408,">"&DATE(2007,12,31))
--ron
 
Hi,

If you are looking for a non-formula approach, you can use pivot tables a
well. Just pivot the data and drag th dates column in the row and data
area. Now Group the dates in the row area by years and you can now see the
count of hires by year

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Back
Top