Go Back   TechArena Community > Software > Windows Software
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



What excel function do I use to search for the number "4" for a date range of 1/1/2012 - 1/31/2012?

Windows Software


Reply
 
Thread Tools Search this Thread
  #1  
Old 09-03-2012
Member
 
Join Date: Mar 2012
Posts: 2
What excel function do I use to search for the number "4" for a date range of 1/1/2012 - 1/31/2012?
  

Dear excel users. Need your help. Anyone know how to count the number of times a certain number or word is used in a column over a certain date range. I know how to find the number of times a number is entered on a cumalative basis: Fx=COUNTIF(F3:F498,"4"). In this case F3:F498 is the colum with the set of numbers i'm looking at. "4" is what i'm searching for. However I want to add a separate column that has the date the number 4 is entered. This colum is D3:D498 and the dates range from 11/1/2011 to the present. What function do I use to search for the number 4 for a date range of 1/1/2012 - 1/31/2012?

Reply With Quote
  #2  
Old 09-03-2012
Member
 
Join Date: Jan 2006
Posts: 605
Re: What excel function do I use to search for the number "4" for a date range of 1/1/2012 - 1/31/2012?

You can use this formula...

=SUMIF($A$2:$A$84,">="&$Q$1,OFFSET($A$2,0,MATCH($Q$3,$B$1:$N$1,0)):OFFSET($ A$84,0,MATCH($Q$3,$B$1:$N$1,0)))-SUMIF($A$2:$A$84,">"&$Q$2,OFFSET($A$2,0,MATCH($Q$3,$B$1:$N$1,0)):OFFSET($A$ 84,0,MATCH($Q$3,$B$1:$N$1,0)))
Reply With Quote
Reply

  TechArena Community > Software > Windows Software
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "What excel function do I use to search for the number "4" for a date range of 1/1/2012 - 1/31/2012?"
Thread Thread Starter Forum Replies Last Post
AVG 2012 error after update, "not active" ID protection is "disabled" Aadhar2011 Networking & Security 5 06-05-2012 04:32 AM
Getting "No Signal" message when trying to import old VHS tape files in Creator 2012 Pro Sru S Windows Software 6 16-01-2012 08:39 AM
"Unspecified Error" Message When Starting‎ AVG 2012 Mactron Networking & Security 5 30-11-2011 01:19 PM
Getting "Error 3048 3" on Norton Internet Security 2012 beta Harshsss Networking & Security 5 08-09-2011 11:01 AM
Excel's Time Capture ("Insert a static date or time") Function: Is it possible to have it capture times down to the second? oogoog747 Windows Software 2 10-04-2009 09:36 AM


All times are GMT +5.5. The time now is 01:30 AM.