Thanks, Roger, that worked beautifully.
Felsa


On Nov 17, 11:49 am, "Roger Govier" <rogerattechnology4NOSPAMu.co.uk
wrote:
Hi

Try
=COUNTIFS(A1,""&TODAY(),B1,"")

--
Regards
Roger Govier

"Felsa Satlow" wrote in message

...



On Sep 18, 5:38 pm, Jim wrote:
Has anyone experienced any substantial errors from theCountifsFormula?

A B C
1 15 51 30

3 20 30 18
4 20 15 18
5 15 51 30

COUNTIFS(A3:C3,A1,A4:C4, B1,A5:C5, C1) = 0 when it should equal
1

Is my syntax wrong? This what the formula produces?

Any ideas?

I have a similar problem, which I thought I posted earlier today. I
have the following cells:
a b c
1 2/15/08
countifs(a1,""&today(),b1,"="&"")

Cell c1 returns 0 instead of 1. Any ideas?- Hide quoted text -

- Show quoted text -