Microsoft Office Courses, Microsoft Office Training, e-learning, Worthing, Brighton, Sussex, Surrey, Hampshire, London
 
Microsoft Office Courses, Microsoft Office Training, e-learning, Worthing, Brighton, Sussex, Surrey, Hampshire, London

On Site Training

 
Microsoft Office Courses, Microsoft Office Training, e-learning, Worthing, Brighton, Sussex, Surrey, Hampshire, London

Web design

 

If you like this site, let us create a web site for you.

Contact us for a quote.

 
 
 
Microsoft Office Courses, Microsoft Office Training, e-learning, Worthing, Brighton, Sussex, Surrey, Hampshire, London

Corporate portraits

 
Portraits for promotional material, web sites or just to decorate your office walls. See Kate's recent commissions
 
 
 
Microsoft
Office Training
SEO & Social Media Training   On-site Training Prices   Free Training
Materials
Client Feedback About Contact
Microsoft Office Computer Courses: Brighton, Worthing, Haywards Heath, Portsmouth, Crawley, Chichester, Sussex, Surrey and London
Microsoft Office Courses, Microsoft Office Training, e-learning, Worthing, Brighton, Sussex, Surrey, Hampshire, London

Free Excel Training COUNTIFS

 

 

Microsoft Office Training > Excel Training > Free Computer Training > COUNTIFS

Please feel free to use this content on your web site, but please include the links at the end

Excel Training COUNTIFS

  1. This function is like the COUNTIF function but it allows you to add more than one set of criteria for your count. Here is an example:

  2. I want to count the number of deposit accounts that a held in the Brighton branch. This is how I would do it:

  3. First of all I’ll click into the cell where I want the formula to go, then...
  4. I’ll click on Insert function button on the formula bar – it’s the button with fx on it.
  5. Then I’ll search for the COUNTIFS function



  6. I’ve clicked on OK


  7. I’ve now got to express my first criteria – the fact that I’m only interested in accounts held in Brighton



    Criteria_range1 is the Branch column: A2:A21
    Criteria1 is Brighton

  8. Now I’ve got a second set of boxes to fill in to express the additional criteria: the fact that I only want to count deposit accounts.



    Criterai_range2 is the Account Type column C2:C21
    Criteria2 is Deposit

  9. I’m now finished, so I’ll click on OK. The answer I got was 2. There are two deposit accounts held at the Brighton branch.

Microsoft Office Training with Blue Pecan Computer Training. Tailored Microsoft Excel Training. Microsoft Excel Training Surrey



 

 

 
Microsoft Office Courses, Microsoft Office Training, e-learning, Worthing, Brighton, Sussex, Surrey, Hampshire, London

More COUNTIFS offerings

 
 

 

Home |   On-site Training  |   Prices   |   Client Feedback  |   About Us |   Contact Us

Copyright (c) 2008 Blue Pecan. All rights reserved.