Countif criteria

GaryB · Apr 5th, 2002, 02:05 AM

I'm sure this must be simple but it's driving me nuts - I'm trying to count all the dates in a column that are in the future, but the syntax is beating me.
=COUNTIF(A:A,TODAY()) counts all the examples with todays date, but what have I got to do to change the formula to count if >today() - adding the ">" produces a helpful "The formula you typed contains an error" message.

Thanks for your time

GaryB

Ian Mac · Apr 5th, 2002, 02:13 AM

Quote:

On 2002-04-05 01:05, GaryB wrote:
I'm sure this must be simple but it's driving me nuts - I'm trying to count all the dates in a column that are in the future, but the syntax is beating me.
=COUNTIF(A:A,TODAY()) counts all the examples with todays date, but what have I got to do to change the formula to count if >today() - adding the ">" produces a helpful "The formula you typed contains an error" message.

Thanks for your time

GaryB

you need to put ""'s round the > and and &.

=COUNTIF(A:A,">"&TODAY())

It's funny because you did the ">" in your question.

GaryB · Apr 5th, 2002, 02:24 AM

Doh!! How dumb do I feel?

Thanks for that Ian

G

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 5th, 2002, 02:05 AM	#1
GaryB Board Regular Join Date: Feb 2002 Location: Essex, England Posts: 458	I'm sure this must be simple but it's driving me nuts - I'm trying to count all the dates in a column that are in the future, but the syntax is beating me. =COUNTIF(A:A,TODAY()) counts all the examples with todays date, but what have I got to do to change the formula to count if >today() - adding the ">" produces a helpful "The formula you typed contains an error" message. Thanks for your time GaryB

Apr 5th, 2002, 02:24 AM	#3
GaryB Board Regular Join Date: Feb 2002 Location: Essex, England Posts: 458	Doh!! How dumb do I feel? Thanks for that Ian G