Hi,

Try this

=(SUMPRODUCT(--($B$9:$B$16=3.25),--($D$9:$D$16=1001),--($A$9:$A$16=A5)))-(SUMPRODUCT(--($B$9:$B$16=3.25),--($D$9:$D$16=1001),--($A$9:$A$16=A5+30)))

If 1001 is really text put the quotes back, this treats 1001 as a number.

Mike


"Laury" wrote:

Trying to count the # times that 3.25 shows up in rows that meet multiple
criteria.

I've got this formula working with 2 variables:
=SUMPRODUCT(--($B$9:$B$16=3.25),--($D$9:$D$16="1001"))

But I want to add another and that seems to foul it up (returns 0, instead
of the correct count #). My last two criteria are to limit it to within 30
days of a date. Any ideas what I have wrong here?
=SUMPRODUCT(--($B$9:$B$16=3.25),--($D$9:$D$16="1001"),(--($A5-($A$9:$A$16))<30))