Excel Formula for Counting Values on a Specific Condition

Asked By cgabriel 10 points N/A Posted on - 04/13/2012

Hello there!

I need the help of some MS Excel Experts here.

I wanted to count the number of values wherein a condition is given.

For example, I wanted to count how many values there which is more than 500.

It should return the number of values having more than 500.

What is the formula for this guys.

I need it ASAP.

Thanks.

• Status: Open
• Question Views: 834
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS Excel

Best Answer by piasmun

Go To Solution

Best Answer

Best Answer

Answered By piasmun 0 points N/A #99070

Excel Formula for Counting Values on a Specific Condition

Hello,

Pleasant day.

Which I have understand from the question is you wanted to count your number of values which is more than 500.

In this case You can first numbering the values in a numerical order and set the serial number, or better be provise them alphabetical order name which can be search easily. For example you can named them A1 which are more than 500.

A for less than 500 etc.Now you can press (Ctrl+F) for A1 which are more than 500.

Then it will show your all the more than 500 values in a page.

And after that if you want to return, you just press cancel and come back to the original page.

Hope this will help you.

Regards

piasmun

About piasmun

Questions
0

Answers
1

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 04/15/2012
• Question Category: MS Excel

Answered By leeqaz 0 points N/A #99071

Excel Formula for Counting Values on a Specific Condition

Hi,

You may use the formula =countif(range,criteria)

Range would be the range of cells you would want to count, e.g. entire Column A or Row 5, etc.

Critera would be the details you want to be counted.

Example:

=countif:(A:A,">500")

This would return a number wherein it will count the total number of cells that are greater than 500 in Column A.

=countif(C:C,"=264")

This would return a number wherein it will count the total number of cells that are equal to 264 in Column C.

Thanks! 🙂

About leeqaz

Questions
0

Answers
2

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 04/20/2012
• Question Category: MS Excel