If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




sumif, countif, datedif formula
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 
Ads 
#2




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 
#3




sumif, countif, datedif formula
On Sun, 24 May 2009 10:21:01 0700, 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 You can use COUNTIF also: For 2007, something like: =COUNTIF(K3:K1408,">="&DATE(2007,1,1))  COUNTIF(K3:K1408,">"&DATE(2007,12,31)) ron 
#4




sumif, countif, datedif formula
Hi,
If you are looking for a nonformula 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 "v1rt8" > wrote in message ... > 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 
Thread Tools  
Display Modes  


Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
Sumif, SumProduct, CountIf Formula Help  Jeremy  Excel Discussion (Misc queries)  3  April 23rd 08 05:18 PM 
CountIf, SumIf formula ques.  jmfrank  Excel Worksheet Functions  1  January 9th 08 10:18 PM 
Help  I need to combine both a SUMIF and COUNTIF into one formula  Natty  Excel Worksheet Functions  7  April 4th 07 06:02 PM 
Countif, Match or Sumif Formula  Gunjani  Excel Worksheet Functions  4  March 29th 06 05:22 PM 
Which formula to use? countif, sumif, sumproduct  zubee  Excel Discussion (Misc queries)  3  September 2nd 05 08:16 PM 