Btwn to date entries
 

Firstly, Thanks Frank it works like a dream.
=SUMPRODUCT(--(B1:B100<""),--(A1:A100<""),--(B1:B100<=TODAY()))

I thought I could work the rest by myself but I have another question.

I am now trying to add up the number of rows which have date entries from
two columns, which using the current date is on or after column B and before
or on column C, and only if there is an entry on the same row in another
specified column A.

for example
A B c
1 x 12/12/2004 14/12/2005
2
3 r 10/10/2004 12/12/2004
4 t

The total for this would be 1 (row 3)

Many Thanks again

Hi
try:
=SUMPRODUCT(--(B1:B100<""),--(A1:A100<""),--(C1:C100<"")--(B1:B100=
TODAY()),--(C1:C100<=TODAY()))

--
Regards
Frank Kabel
Frankfurt, Germany

"dave" schrieb im Newsbeitrag
...

Firstly, Thanks Frank it works like a dream.
=SUMPRODUCT(--(B1:B100<""),--(A1:A100<""),--(B1:B100<=TODAY()))

I thought I could work the rest by myself but I have another
question.

I am now trying to add up the number of rows which have date entries
from
two columns, which using the current date is on or after column B and
before
or on column C, and only if there is an entry on the same row in
another
specified column A.

for example
A B c
1 x 12/12/2004 14/12/2005
2
3 r 10/10/2004 12/12/2004
4 t

The total for this would be 1 (row 3)

Many Thanks again