Sum entries between dates

[Al Mackay]

Wondered if the following was possible with a nested statement?

Have a set of dates and a category type (not every row contains a
date!). Need to be able to sum the dates with the following criteria.

1) Count how many entries that exist in column B where column A is
blank.
2) Count how many entries that exist in column B where column A's date
is is => 04/2004 (month/year)
The end result of this would then be criteria 1 + Criteria 2.

Appreciate your help on this, below is a sample of the data.

Cheers, Al. ( (e-mail address removed) )

EXAMPLE (DATA):
A B
1/3/4 Critical
4/2/4 Critical
3/4/4 Critical
25/5/4 Critical
Critical
4/1/4 Critical

 

[Frank Kabel]

Hi
try
1.
=SUMPRODUCT(--(ISBLANK(A1:A100)),--(B1:B100<>""))

2.
=SUMPRODUCT(--(B1:B100<>""),--(A1:A100>=DATE(2004,4,1)))