Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

countifs function

14 views
Skip to first unread message

Felsa Satlow

unread,
Nov 16, 2007, 2:45:47 PM11/16/07
to
My understanding of this function is that it ANDs multiple criteria.
So, I have a worksheet that has a date (2/15/08) in cell a1 and cell
a2 is blank. Cell a3 has 'COUNTIFS(a1,">"&today(),a2,"="&"")'. Cell 3
shows 0 instead of 1, as I expected. Does anyone know why?

NoodNutt

unread,
Feb 23, 2008, 6:34:17 AM2/23/08
to
I have just started using 2007 myself, and your the second person I have
noticed using "Today()", I have always known date functions as Now().

'COUNTIFS(a1,">"&NOW(),a2,"="&"")'

"NOW() returns Date only whereby using "TODAY()" returns Date & Time which
may be your problem.

HTH
Mark.


Pete_UK

unread,
Feb 28, 2008, 9:17:25 PM2/28/08
to
Check it out in Excel Help - it's actually the other way round.
TODAY() returns the date only, NOW() returns date and time.

Hope this helps.

Pete

ilia

unread,
Mar 2, 2008, 10:15:55 AM3/2/08
to
Easy enough to check.

=TODAY()=INT(TODAY())
=NOW()=INT(NOW())

return, respectively

TRUE
FALSE

Was this thread really started on 11/16/2007? At this point, 2/15/08
is < TODAY(). Also, a somewhat odd usage of COUNTIFS, normally you'd
expect a range to be used for the odd argument.

0 new messages