Counting data that meets 3 different Criteria

J

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


Jenny S said:
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!

Dave Peterson said:
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.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting multiple criteria 5
Page numbering with Merged Document and IF statements 1
Counting multiple occcurrences between date range 3
IRR vs XIRR 8
Finding the weighted average of text that have been given values 1
Sumproduct? 1
How do I add a variable range of columns depending on criteria 0
Two Criteria COUNTIF 7

Top