| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
countif function hassle
Im working on two sheets On sheet 1, I wish cell e37 to enter the number of times a date is placed in the column h34:h44. (These dates will be randomly entered manually later) The dates will fall on or between the current day "today()" and a date enntered in sheet 2, cell N2 Every syntax I try falls over and I keep getting zero values in E37. Its got to be easy but it escapes me. Any help out there? -- dond ------------------------------------------------------------------------ dond's Profile: http://www.excelforum.com/member.php...o&userid=25477 View this thread: http://www.excelforum.com/showthread...hreadid=393816 |
|
#2
|
|||
|
|||
|
Dond,
Try this =COUNTIF(H34:H44,"<="&Sheet2!N2)-COUNTIF(H34:H44,"<"&TODAY()) -- HTH Bob Phillips "dond" wrote in message ... Im working on two sheets On sheet 1, I wish cell e37 to enter the number of times a date is placed in the column h34:h44. (These dates will be randomly entered manually later) The dates will fall on or between the current day "today()" and a date enntered in sheet 2, cell N2 Every syntax I try falls over and I keep getting zero values in E37. Its got to be easy but it escapes me. Any help out there? -- dond ------------------------------------------------------------------------ dond's Profile: http://www.excelforum.com/member.php...o&userid=25477 View this thread: http://www.excelforum.com/showthread...hreadid=393816 |
|
#3
|
|||
|
|||
|
dond,
Sounds like your problem might be that you're counting an exact day when your date list might have decimal places which aren't showing. That is, you're trying to count "August 1, 2005" when your list includes "August 1, 2005 10:03AM", so they aren't counted. Eric "dond" wrote: Im working on two sheets On sheet 1, I wish cell e37 to enter the number of times a date is placed in the column h34:h44. (These dates will be randomly entered manually later) The dates will fall on or between the current day "today()" and a date enntered in sheet 2, cell N2 Every syntax I try falls over and I keep getting zero values in E37. Its got to be easy but it escapes me. Any help out there? -- dond ------------------------------------------------------------------------ dond's Profile: http://www.excelforum.com/member.php...o&userid=25477 View this thread: http://www.excelforum.com/showthread...hreadid=393816 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| Countif Function -Nested | Excel Discussion (Misc queries) | |||
| clock | Excel Worksheet Functions | |||
| How do I use COUNTIF in a SUBTOTAL function to differentiate the . | Excel Worksheet Functions | |||
Linear Mode
