=sumproduct((D1:D100=AC1:AC100)*(R1:R100="KJ"))
--
David Biddulph

"michelledean via OfficeKB.com" <u11299@uwe wrote in message
news:804eecce1b09c@uwe...
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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200802/1