1 / 6

Excel COUNTIF and SUMIF Functions Explained

Learn how to use Excel COUNTIF and SUMIF functions to count and sum values based on specific criteria. Find examples and instructions for these useful functions in Excel.

tovi
Télécharger la présentation

Excel COUNTIF and SUMIF Functions Explained

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Excel Functions By Mrs. Erum Tanveer

  2. COUNTIF() =countif(range of cells,criteria)

  3. Counts the number of cells that have the same content as the criteria. The following example shows the number of cells that contain the number 100. The formula entered in the B1 cell is =countif(A1:A3,100) .

  4. Q) Use countif() to find out the number of Disk in the column named Product a) =countif(a2..a7,”Disk”) b) =countif(a2..a7, a2) c) =countif(b2..b7,”Disk”) d) =countif(b2..b7,”a2”)

  5. SUMIF() =sumif(range of cells,criteria)

  6. This function adds numbers that have the same value. Place the cursor in the B3 cell.Enter this formula: =sumif(A1:A3,100) .

More Related