Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list. Examples. Data Data =COUNTIF(A2:A5,”apples”) Counts the number of cells with apples in cells A2 through A5. The result is 2. How do […]

Where do I find my spam folder? B. On the Mobile App Log in to your Gmail account on your iPhone or Android device. Click the three bars (burger icon) in the upper-left corner to open the main menu. Scroll down, and you’ll find the spam folder. To clear your spam folder in one go, […]

Go to Picture Format or Shape Format and select Arrange > Wrap Text. If the window is wide enough, Word displays Wrap Text directly on the Picture Format tab. Choose the wrapping options that you want to apply. For example, In Line with Text, Top and Bottom, and Behind Text. Why is my text not […]

The copyright symbol is usually followed by the name of the copyright holder and the year of the material’s publication or first use. You may copyright almost any kind of written material, from a website to a book or poem. How do you properly mark a copyright? The copyright notice generally consists of three elements: […]

To fit an image into a shape in Google Slides, you can mask an image. On your computer, open a presentation. Click the image you want to mask. At the top, next to Crop , click the Down arrow . Click the shape you want. Your shape will mask your image. To adjust your shape, […]

How to Pause All Notifications on Your iPhone Open the Settings app on your iPhone. Then tap Do Not Disturb. Next, toggle the slider next to Do Not Disturb. You will know it is on if it is green. Finally, tap Always under Silence. All notifications and phone calls will be turned off while Do […]

Clear the read-only status of a workbook Open the Finder and select the workbook you no longer want to be read-only. On the Action pop-up menu. , click Get Info. On the General pane, clear the Locked check box. How do I turn off read only in Excel? Right-click on the Excel file you want […]

INDEX MATCH is a clever way to perform a two-way lookup in Excel by combining the power of the INDEX and MATCH functions. It is used as a workaround for the limitations of VLOOKUP, and offers great flexibility once you understand how it works. What is INDEX match used for? The INDEX MATCH function is […]

an act or instance of subtracting. Mathematics. the operation or process of finding the difference between two numbers or quantities, denoted by a minus sign (−). What is a subtract in math? Subtraction is the operation of taking the difference of two numbers and . Here, is called the minuend, is called the subtrahend, and […]

Leave a group To do so, go to groups.google.com and click the group you wish to leave. Click My membership settings. Click Leave Group at the top of the page. How do you remove yourself from a group email? Select the group you want to leave. Click on the group name to pull up the […]