Is there a way to match todays date with 2 other data ranges? One is in a
named range on a data sheet and the other in a row on the page. When
comparing the first two, there would only be the possibility of 1 match (I've
been using an array formula for that.

{=SUM(COUNTIF(RangeName,A1:AA1))}

The end result is to populate a cell with a 5 when all three match each
other. I hope this isn't too confusing.

I'm trying to clarify a previous post.

Do you mean

=IF(AND(COUNTIF(RangeName,TODAY())0,COUNTIF(A1:AA 1,TODAY())0),5,"")

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"ben simpson" wrote in message
...
Is there a way to match todays date with 2 other data ranges? One is in a
named range on a data sheet and the other in a row on the page. When
comparing the first two, there would only be the possibility of 1 match
(I've
been using an array formula for that.

{=SUM(COUNTIF(RangeName,A1:AA1))}

The end result is to populate a cell with a 5 when all three match each
other. I hope this isn't too confusing.

I'm trying to clarify a previous post.