Reply With Quote
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 :-)
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.
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 :-)
I think you may want to take a look at Solver.
Regards,
Zack Barresse
Posting Permissions
Bookmarks