Skip to main content

Posts

Featured

How To Use Countif Formula

What Does It Do ? This function counts the number of items which match criteria set by the user. Syntax: =COUNTIF(RangeOfThingsToBeCounted,CriteriaToBeMatched) The criteria can be typed in any of the  following ways. To match a specific number type the number, such as =COUNTIF(A1:A5,100) To match a piece of text type the text in quotes, such as =COUNTIF(A1:A5,"Hello") To match using operators surround the expression with quotes, such as =COUNTIF(A1:A5,">100") Formatting: No special formatting is needed.

Latest Posts

Auto Sum Short Cut Key

Count total words in a cell

How to Use SUM Formula

Age Calculation

Tips For Cleaning The Laptop

Tip To Control Your Computer Like A Robot

How To Set A Video As Desktop Background

Why A Hard Drive Has Less Storage Space Than Promised?

Learn How To Encypt Hard Drive 0r USB Drive

Learn About How To Protect Laptop From Theft