Help creating functions in Excel

[allcarfan]

We are trying to create a function in Excel through VB where it counts all of the fields whose text is "Accept" - but in another field its manufacturers name must be equal to a manufacturers name in another field in another sheet.

basically a countif function, with multiple criteria. We tried CountA, but it didnt seem to work. We can get the Count if Function to work, but it counts ALL of the 'accepted' in a given column without regards to the manufacturer in another column.

Am I clear?

Shane

 

[meintsi]

COUNTIF(AND(acceptmatch,namematch)) *Remember.......
If you don't use your head,
your going to have to use your feet.

 

[ETID]

Look into the dcount function...from the help / paper clip guy