LikeOffice    Excel Help

EXCEL Utility
Customized Ribbon

- Compare worksheets
- Database analysis
- Stock to your Excel
- Password recovery
- and more...
Excel Formula
List of Excel
Formula examples
 
Excel Question
Ask us an Excel Question

 

Sumproduct Lookup Sumif Countif Unique Percentile

 

1. Count based on all values that are higher then 30    
2. Count based on one condition with *    
3. Count based on one condition only    
4. Count how many time the range E12:F12 appears in Column A (rng_a)    
5. Count based on 2 or more conditions    
6. Count totals that are greater than 20 and less than 50    
7. Countifs with 2 or more conditions    





1. Count based on all values that are higher then 30

Count based on all values that are higher then 30.


Formula:

=COUNTIF(RNG_H,">30")



Answer = 6

Top

2. Count based on one condition with *

Count based on one condition with *.


Formula:

=COUNTIF(RNG_C,E12&"*")

E12 = Col

Answer = 5

Top

3. Count based on one condition only

Count based on one condition only.


Formula:

=COUNTIF(RNG_C,E12)

E12 = Cola2

Answer = 4

Top

4. Count how many time the range E12:F12 appears in Column A (rng_a)

Count how many time the range E12:F12 appears in Column A (rng_a).


Array Formula:

{=SUM(COUNTIF(RNG_A,E12:F12))}

E12 = 312
F12 = 313

Answer = 4

Top

5. Count based on 2 or more conditions

Count based on 2 or more conditions.
The COUNTIFS function, similar to Excel's COUNTIF function, counts up the number of times data in two or more ranges of cells meets multiple criteria.

Formula:

=COUNTIFS(RNG_C,E12,RNG_E,F12)

E12 = Cola2
F12 = b

Answer = 3

Top

6. Count totals that are greater than 20 and less than 50

Count totals that are greater than 20 and less than 50.
The COUNTIFS function, similar to Excel's COUNTIF function, counts up the number of times data in two or more ranges of cells meets multiple criteria.

Formula:

=COUNTIFS(RNG_H,">20",RNG_H,"<50")



Answer = 4

Top

7. Countifs with 2 or more conditions

Countifs with 2 or more conditions.
The COUNTIFS function, similar to Excel's COUNTIF function, counts up the number of times data in two or more ranges of cells meets multiple criteria.

Formula:

=COUNTIFS(RNG_C,E12,RNG_E,F12)

E12 = cola2
F12 = b

Answer = 3

Top
 




Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation.
©2003-2011 LikeOffice - Privacy Policy - Contact us

[Top]