| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
