Counting data that meets 3 different Criteria

[Jenny S]

IT WORKS - my equation was missing one little comma!!!!
Thanks for all your help. I can achieve what I wanted to.

Thanks again

Thankyou so much, have put some sample data in a new spreadsheet and it
works!!!!! now just need to figure out the main data!
Thanks heaps - at least I know it should work!

I don't see anything wrong with your formula--so it has to be the data.

Set up a test worksheet and try your formula there. Use just enough data to get
a result.