98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Countif?
Countif?
Resolved · Medium Priority · Version 2007
Thu 29 Jan 2009, 11:50Delegate Fiona said...
Fiona has attended:
Excel Advanced course
Countif?
I want to count up the number of times data in two or more ranges of cells meets multiple criterion. The ranges are not the same size so countifs won't work but I don't know what else to use.
Fri 30 Jan 2009, 14:15Trainer Amanda said...
RE: Countif?
Hello Fiona
Thank you for your question.
Would DCOUNT work? You can use this to count if your data is arranged in columns with headings.
Kind regards
Amanda
Thu 5 Feb 2009, 10:41Delegate Fiona said...
RE: Countif?
Hi Amanda,
Doesn't Dcount just work for numeric values? One of my columns contained text. As my problem was that my ranges were not the same size, I created a new column with one set of criteria that I needed to use then used Countifs to find matching criteria in two columns of equal size and that seemed to work. Worked out the solution by trial and error but seem to have got a result.
Regards,
Fiona
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Selecting your working rangeIn excel if you have an area you want to highlight, press Ctrl + * or Ctrl+Shift+8 (to get the *). This will select your working range. |
