Formula help please

[michelledean via OfficeKB.com]

I need a formula to return a count from a database with the following

Column D Column R Column AC
2/25/08 KJ 2/25/08

The formula I need would need to return a count for Column R if Column D and
AC equal the same date and count all cells in Column R that have a KJ in it.
Any help is appreciated.

 

[Max]

One way:
=SUMPRODUCT((D2100=AC2:AC100)*(R2:R100="KJ"))

 

[David Biddulph]

=sumproduct((D1100=AC1:AC100)*(R1:R100="KJ"))