I have a bunch of spreadsheets with the first three columns similar to the attached. The number of “AddrA’s”; i.e, 1, 2, 3 etc in column A will vary as will the number of rows. The AddrA’s are 1 to 56, although not all AddrA numbers will be in each spreadsheet.
For each of the AddrA’s from 1 to 56, I would like to count the number of “Res” (column C) values greater than a certain number, which in the example is 10,000.
I think it is an array formula, but I can’t figure out the logic.
Any suggestions?
Thanks.
