Need help brain is jello now countif multiple criteria with today()

[robertjtucker]

=COUNT(IF((H:H>Today())*(H:H<(today()+15),H:H)))

Some one please give me a hand with this just can not get it to work right. Supposed to be counting the amount of days that are greater than today but are less than 15 days more than today.

Thanks,
Bob

[Domenic]

Try...

=SUMPRODUCT(--(H1:H100>TODAY()),--(H1:H100<TODAY()+15))

Note that SUMPRODUCT does not accept whole column references. But you can define a dynamic range, one that adjusts itself as new data is entered.

Hope this helps!