What's New? | Contact Us

About Us | Site Map     

Home
Access Tips
Excel Tips
Microsoft Office Tips
PowerPoint Tips
Word Tips

 

Weekly Picks

Cool Websites
Publications
Key Trends
Useful Resources
Tech Tips
 
Picks Archives
 
 

Bookmark and Share

Tech Tip of the Week:   February 15 - 28, 2015

COUNTIFS in Excel 2007/2010

We've had the COUNTIF function in Excel for a while. This function allows you to count records in a list that match a single criteria. What's completely new with Excel 20072010 is COUNTIFS which allows you to count records based on multiple criteria.  Sure, there were other ways of doing this before, but none as easy as the COUNTIFS function.  Here's the syntax:

=COUNTIFS(range1,criterion1,range2,criterion2,,range_n,criterion_n)

Makes it really simple to count records in a range that match the criteria you enter in the formula. If you need a little more help, check out this article on the Microsoft web site:  Use the COUNTIFS function in Excel 2007 to analyze data.
 

View all Access Tech Tips

View an alphabetical listing of Access Tech Tips

View all Excel Tech Tips

View an alphabetical listing of Excel Tech Tips

View all Office Tech Tips

View an alphabetical listing of Office Tech Tips

View all PowerPoint Tech Tips

View an alphabetical listing of PowerPoint Tech Tips

View all Word Tech Tips

View an alphabetical listing of Word Tech Tips

   

"The only thing necessary for the triumph of evil is for good people to do nothing." Edmund Burke  View Past Quotes

frank@createthefuture.com susan@createthefuture.com

2015 Creative Information Systems 

 In Association with Amazon.com

Revised: February 25, 2015