Excel Formula for Counting Values on a Specific Condition

Asked By 10 points N/A Posted on -
qa-featured

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.

SHARE
Best Answer by piasmun
Best Answer
Best Answer
Answered By 0 points N/A #99070

Excel Formula for Counting Values on a Specific Condition

qa-featured

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

Answered By 0 points N/A #99071

Excel Formula for Counting Values on a Specific Condition

qa-featured

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! 🙂

Login/Register to Answer

Related Questions