PERCENTIF

Returns the percentage of a range that meets a condition.

Parts of a PERCENTIF function

PERCENTIF(range, criterion)

Part

Description

range

The range that is tested against criterion.

criterion

The pattern or test to apply to range.

Sample Usage

PERCENTIF(A1:A10, ">20")

PERCENTIF(A1:A10, "Paid")

Notes

  • If range contains text to check against, criterion must be a string. criterion can contain wildcards including ? to match any single character or * to match zero or more contiguous characters. To match an actual question mark or asterisk, prefix the character with the tilde (~) character (i.e. ~? and ~*). A string criterion must be enclosed in quotation marks. Each cell in range is then checked against criterion for equality (or match, if wildcards are used).
  • If range contains numbers to check against, criterion may be either a string or a number. If a number is provided, each cell in range is checked for equality with criterion. Otherwise, criterion may be a string containing a number (which also checks for equality), or a number prefixed with any of the following operators:  =, >, >=, <, or <=, which check whether the range cell is equal to, greater than, greater than or equal to, less than, or less than or equal to the criterion value, respectively.

  • PERCENTIF supports only evaluating a single criterion.

Examples

 

Expense

Today

Coffee

$4.00

   

Newspaper

$1.00

   

Taxi

$10.00

   

Golf

$26.00

   

Taxi

$8.00

   

Coffee

$3.50

   

Gas

$46.00

   

Restaurant

$31.00

   

...

...

   
       
       

range

criteria

Result

Formula

A2:A9

"Taxi"

0.25

=PERCENTIF(A2:A9, "Taxi")

       
       

range

criteria

Result

Formula

B2:B9

>=10

0.5

=PERCENTIF(B2:B9, ">=10")

       
       

range

criteria

Result

Formula

B2:B9

10

0.5

=PERCENTIF(B2:B9, ">="&B22)

       
       

range

criteria

Result

Formula

A2:A9

"G*"

0.25

=PERCENTIF(A2:A9, "G*")

       
 

Related functions

  • COUNTIF
  • COUNTIFS
Was this helpful?
How can we improve it?