B1 is Header for the Database
to show rows of information it is correctly done, so
B1 has been entered with this formula to call for the record information
='Filed.Record' that is:
=('Lighting Device'.'Fixture Cost')
If you replace it with anything else, like
=B1
I can't see how your database rows are remain valid?
I am still puzzled how do you summarize on top at B1 cell
in my case the formatting didn't work, it always shows 28 no matter what formatting
I use for the cell: General, Decimal with so many digits etc.
Please advise what was the solution.
Tx,