Forum home » Delegate support and help forum » Microsoft Excel Training and help » Countif?

Countif?

ResolvedVersion 2007

Thu 29 Jan 2009, 11:50 Delegate 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:15 Trainer 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:41 Delegate 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 courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Using the Quick Access Toolbar in Excel2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Excel hints and tips

Countif?

Countif?

RE: Countif?

RE: Countif?

Excel articles

Excel tip:

Using the Quick Access Toolbar in Excel2010