新聞財經娛樂♬資訊 News Economy

I have a spreadsheet with 90,000 rows and 10 columns. I need to find out how many of the cells contain a specific value. Let's say 538. How many cells have 538 their cell. I've tried to sort but the it's so unwieldy the program craps out. Sorting hangs and never recovers.

Any quick and simple method to extract this one bit of info?

NBVC is correct,  and  I modify this from him

=COUNTIF(A:Z,538)

That you don't need to consider the number of row  to be searched when
put the formula out of A:Z range , ie, put it at  Cell AA

Duncan

You can use COUNTIF

e.b.

=COUNTIF(A1:Z100,538)