Home » Office

Excel SUM or COUNT only certain items using SUMIF COUNTIF functions

Written By: admin on March 22, 2010 4 Comments

See how to use the SUMIF and COUNTIF functions to add and count given a certain condition. With this trick you can add only the sales for the salesperson Tina — or count them! Also, learn the super fast keyboard shortcuts for naming multiple ranges. Count words text based on a Condition. Count words text based on criteria. SUM Values based on a Condition. SUM Values based on criteria.

Digg this!Add to del.icio.us!Stumble this!Add to Techorati!Share on Facebook!Seed Newsvine!Reddit!

4 Responses to “Excel SUM or COUNT only certain items using SUMIF COUNTIF functions”

  1. ExcelIsFun on: 22 March 2010 at 10:20 am

    You are welcome!

  2. ranjan1961 on: 22 March 2010 at 11:13 am

    Giid job .. its very usefull.
    tkns

  3. ExcelIsFun on: 22 March 2010 at 11:35 am

    Dear limbo55,

    No Problem! I am happy to provide useful tips!

    If you keep watching and rating, I’ll keep making useful videos!!

    –ExcelIsFun

  4. limbo55 on: 22 March 2010 at 11:52 am

    You’re very enthusiastic and quite knowledgeable. Thanks for the video, very helpful material.

Leave a Reply:

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

  Copyright ©2009-2010 Best Indian Bloggers, All rights reserved.| WPElegance2Col theme by Techblissonline.com