On Fri, 4 Feb 2005 20:52:34 -0800, "Biff" wrote:
o change the formula to:
=SUMPRODUCT(--(J2:J250=TODAY()+29),--(I2:I250=.01))
Ignore my message. I see you addressed SUM vs COUNT in your previous post.
But I think the OP wanted a SUM; perhaps not.
--ron
|