Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data count

Data count

ResolvedVersion 2003

Thu 9 Dec 2010, 17:12 Delegate Paul said...

Paul has attended:
Excel Intermediate course

Data count

how do you count the number of instances there are in a set of data with conditions based on the content of other cells?

Sun 12 Dec 2010, 15:50 Trainer Nafeesa said...

RE: data count

Hi Paul

Thank you for your question.

To further clarify, do you mean if you change the condition/value of a particular cell, e.g C2 you would like to automate a calculation to identify the number of instances that condition appears in a set data range, i.e. A1:A20.

Regards,

Nafeesa

Microsoft Office Specialist Trainer

Mon 20 Dec 2010, 16:14 Trainer Nafeesa said...

Will be marked as resolved in 5 days

Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.

Mon 27 Dec 2010: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Edit and format multiple worksheets in one operation

To select two or more non-adjacent worksheets, click on the tab of each worksheet, while holding down the [CTRL] key.
To select two or more adjacent worksheets, click on the tab of the first worksheet and then on the tab of the last worksheet, while holding down the [SHIFT] key.
Enter or modify your data and apply the necessary formatting options to the sheet that's displayed

View all Excel hints and tips

Data count

Data count

RE: data count

Will be marked as resolved in 5 days

Excel articles

Excel tip:

Edit and format multiple worksheets in one operation