• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 13. Analyzing Data with Lists > List Functions That Don't Require a Cri...

List Functions That Don't Require a Criteria Range

Excel has two list functions that enable you to specify the criteria as an argument rather than a range: COUNTIF() and SUMIF().

Using COUNTIF()

The COUNTIF() function counts the number of cells in a range that meet a single criterion:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint