Say you have ="A CO 1-68" in D1 and "G-1" in E1, you can write:
=SUMPRODUCT((A2:A6D1)*(C2:C6=E1))

HTH
--
AP


"Ardus Petus" a écrit dans le message de news:
...
=SUMPRODUCT((A2:A6="A CO 1-68")*(C2:C6="G-1"))

HTH
--
AP

"CERYD" a écrit dans le message de news:
...
I have a Workbook And I dont know what Formula To Use Ive Tried DCOUNT And
SUM Product and Others Some One Help me out

UNIT Date to BN Status
205TH MI N/A G-1
A CO 1-68 11feb06 Complete
B CO 1-68 N/A G-1
A CO 1-68 11 OCT BN
C CO 1-68 Na G-1

Example of what I want to do is---
IF Unit Equals A CO 1-68 then Count how Many Are G-1 So with this
I would Get 1

Any one Can Help Me????