Thanks for the help but two things:

When using the formula, Excel keeps say it is a circular reference.

Secondly, I inherited this workbook and do not have the time to change
it to a pivot table.

T


Dave Peterson wrote:
An unfortunate line break:

=SUMPRODUCT(--($G$4:$G$5000="Consulting"),
--(TEXT($S$4:$S$5000,"mmm yy")="Sep 06"),
--($D$4:$D$5000="Proposal"))



daddylonglegs wrote:

Hi Ted

for this sort of counting with multiple conditions SUMPRODUCT is probably
the best option. Assuming your dates are in column S try this

=SUMPRODUCT(--($G$4:$G$5000="Consulting"),--(TEXT($S$4:$S$5000,"mmm
yy")="Sep 06"),--($D$4:$D$5000="Proposal"))

--

Dave Peterson