Assuming no header rows enter this in the first row of the col you have
inserted

=SUMPRODUCT(--(D:D=D1),--(B:B=B1))

In Excel 2003 replace D:D with D1:D3000 (if 3000 is the last row) and B:B
with B1:B3000

"Jim Prentice" wrote:

I have a database built in Excel (about 3000 rows and 25 columns). The
database grows in rows daily. One of the columns (say D), lists street
addresses, another (sayB), lists the nature of the callout to that address
(three different callout reasons could occur). I have inserted a blank column
and in this column I want to enter a formula (in each row) to give the number
of times a callout has occurred for that address for its corresponding
reason. With just one criteria, that of how many times a callout to an
address has occurred the formula COUNTIF(D:D,Dline number) works. I am not
sure how to bring in the second criteria €“ I have been trying SUMPRODUCT
without success.

Any help would be greatly appreciated.