Results 1 to 2 of 2

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

  1. #1
    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?

  2. #2
    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)))

Similar Threads

  1. AVG 2012 error after update, "not active" ID protection is "disabled"
    By Aadhar2011 in forum Networking & Security
    Replies: 5
    Last Post: 06-05-2012, 04:32 AM
  2. Replies: 6
    Last Post: 16-01-2012, 08:39 AM
  3. "Unspecified Error" Message When Starting‎ AVG 2012
    By Mactron in forum Networking & Security
    Replies: 5
    Last Post: 30-11-2011, 01:19 PM
  4. Getting "Error 3048 3" on Norton Internet Security 2012 beta
    By Harshsss in forum Networking & Security
    Replies: 5
    Last Post: 08-09-2011, 11:01 AM
  5. Replies: 2
    Last Post: 10-04-2009, 09:36 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •