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
|
|||
|
|||
COUNTIF problem with NOW()
=COUNTIF(ALL!AC2:AC1000,"NOW()-21") This is the formula I'm using. I'm trying to determine how many dates in column AC are more than three weeks ago. It's returning a 0 even though it shouldn't. Can anyone see why? THanks. -- Spreadsheet ------------------------------------------------------------------------ Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730 View this thread: http://www.excelforum.com/showthread...hreadid=555028 |
#2
|
|||
|
|||
COUNTIF problem with NOW()
Nel post
*Spreadsheet* ha scritto: =COUNTIF(ALL!AC2:AC1000,"NOW()-21") This is the formula I'm using. I'm trying to determine how many dates in column AC are more than three weeks ago. It's returning a 0 even though it shouldn't. Can anyone see why? THanks. Hi, try this: =COUNTIF(A2:A49,""&TODAY()-21) in this case you should prefer TODAY instead of NOW, because you don't need the time, just th day. -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#4
|
|||
|
|||
COUNTIF problem with NOW()
The NOW formula should not be in quotes. =COUNTIF(ALL!AC2:AC1000,""&NOW()-21) HTH Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=555028 |
#5
|
|||
|
|||
COUNTIF problem with NOW()
Thanks for replying. I'm now using =COUNTIF(ALL!AC2:AC1000,""&TODAY()-21) However, I'm having another problem. What I need to do is this: Of all of the dates more than three weeks ago in column AC, how many of those have a blank cell in column AG? -- Spreadsheet ------------------------------------------------------------------------ Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730 View this thread: http://www.excelforum.com/showthread...hreadid=555028 |
#6
|
|||
|
|||
COUNTIF problem with NOW()
Nel post
*Spreadsheet* ha scritto: Thanks for replying. I'm now using =COUNTIF(ALL!AC2:AC1000,""&TODAY()-21) However, I'm having another problem. What I need to do is this: Of all of the dates more than three weeks ago in column AC, how many of those have a blank cell in column AG? You can use this one: =SUMPRODUCT((ALL!AC2:AC1000(TODAY()-21))*(ALL!AG2:AG1000="")) -- (I'm not sure of names of menues, option and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#7
|
|||
|
|||
COUNTIF problem with NOW()
Franz, I'm not sure why you suggested SUMPRODUCT. I'm only interested in a count. -- Spreadsheet ------------------------------------------------------------------------ Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730 View this thread: http://www.excelforum.com/showthread...hreadid=555028 |
#8
|
|||
|
|||
COUNTIF problem with NOW()
Nel post
*Spreadsheet* ha scritto: Franz, I'm not sure why you suggested SUMPRODUCT. I'm only interested in a count. Trust me. This *is* a count... -- (I'm not sure of names of menues, option and commands, because translating from the Italian version of Excel...) Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#9
|
|||
|
|||
COUNTIF problem with NOW()
The reason I wasn't sure that this was a count is because the formula resulted in a number much larger than the correct answer. Do you have any other suggestions? Thanks. -- Spreadsheet ------------------------------------------------------------------------ Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730 View this thread: http://www.excelforum.com/showthread...hreadid=555028 |
#10
|
|||
|
|||
COUNTIF problem with NOW()
Could you post a sample of your data and what the result should be? Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=555028 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Outlook 2003 *Not Responding* ongoing problem, no solutions | RedHeadedMenace | General Discussion | 0 | December 2nd, 2005 07:31 PM |
Fixing my embedded objects problem | JMF | General Discussions | 2 | December 2nd, 2005 07:47 AM |
Problem Retrieving Printer Object Information | Beverly R | Setting Up & Running Reports | 2 | May 16th, 2005 06:02 PM |
PGP problem | Bob Henson | General Discussion | 0 | June 27th, 2004 11:28 AM |
Simple Countif problem | Worksheet Functions | 2 | October 29th, 2003 12:43 PM |