What I needed help with was determining the numbers in O1-3. O1 is the active records count, so all records that have not been destroyed, minus O2, which is a count of all cells in D with any value entered into them. However, those represent individual records, and I need to know how many

*total*boxes we still have on site, which needs to include a calculation for any boxes that have multiple records in it, like box 1817 below.

I got help here for the array formula in O3, which looks like this:

=SUM(IF(FREQUENCY(IF(NOT(ISNUMBER(O5:O5000)), D5:D5000, ""), IF(NOT(ISNUMBER(O5:O5000)), D5:D5000, ""))>0, 1, 0))-1

=SUM(IF(FREQUENCY(IF(NOT(ISNUMBER(O5:O5000)), D5:D5000, ""), IF(NOT(ISNUMBER(O5:O5000)), D5:D5000, ""))>0, 1, 0))-1

and it worked fine until I went through another huge file room of records and realized that the box naming convention had changed to include leading alphabetical characters (eg. FA-2007-17). The formula will only count any item that is a number and ignores any of the boxes with the alphanumeric naming convention.

Any help on how to change the formula to account for alphanumeric and numeric box titles?

Thanks so much for any help you can offer me! I never realized how powerful Excel was until I started wading through these forums.