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

Posting Permissions

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