excel function countif

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » EXCEL Function COUNTIF

EXCEL Function COUNTIF

resolvedResolved · Urgent Priority · Version 2003

Sophia has attended:
No courses

EXCEL Function COUNTIF

Hi,

I would like to know if there is a formula for "countif" but that could meet two given condition.
So IF A1=10 and B1=A, C1=1.

Thank you very much,

Sofia

RE: EXCEL Function COUNTIF

Hi Sophia

Thank you for your post.

I've attached an example using the cell entries you have provided above, which I think answers your question.

I've coloured the cell containing the formula in yellow.

I hope you find this useful.
Amanda

Attached files...

count_with_conditions.xls

RE: EXCEL Function COUNTIF

Thank you very very much!!!!!!!

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Conditional Formatting in Excel 2010

If you have lots of data in a spreadsheet, you may find that it is easier to read if you highlight some of the values. This is Conditional Formatting and here's how to use it:

1) Select the data you wish to apply the format to and click Conditional Formatting
2) A list of options will then appear, from this list, choose the format you wish to display e.g. find all cells with a value less than 0
3) Excel will then highlight all of these cells

To remove this: select the highlighted cells, click the drop down on the Conditional Formatting icon and select Clear Rules from selected cells.

View all Excel hints and tips


Server loaded in 0.09 secs.