Excel Formula help

[D141376]

Hi,
I wanted to get how many numbers in the list of range numbers are equal to 305.
For ex,there are range of values like 100-110,320-350,405-415,430-445 like this there are around 100 ranges i want to know which formula can give all the range details.

[maninweb]

Hi D141376...

for getting the count of values equal X in a range, you can use...

=COUNTIF(A4:K34;A1)

A4:K34 is the range where you compare the values
A1 is a cell containing the searched value, for example 305

Hope this suits your needs.

Regards :-)

[Zack Barresse]

I think you may want to take a look at Solver.