Formula help please
 

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

Formula help please
 

One way:
=SUMPRODUCT((D2:D100=AC2:AC100)*(R2:R100="KJ"))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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

Formula help please
 

=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