I already gave you answer with both sumproduct and dcounta yesterday, if you
don't understand it you should post in the same thread
with what didn't work etc

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"CERYD" wrote in message
...
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????