Quote:
Originally Posted by Debaser
I'd assume the table is growing. Given that you have a table, you might as well use table references. The #N/A means there aren't any values meeting the criteria. If there should be, which seems to be the case if copying and pasting the same data produces results, then there must be a formatting difference.
|
Tabel in sharepoint is now counting 3039 rows. I wrote the formula with rows for 3 years (using B:B would be too much). Could I adjust formula to actual amount of rows (B$2:B$3039)? Since the formula grows it will adjust to the growing sharepoint.
10-06-2017, 05:29 AM
Similar Threads
How do I make a checkbox or dropdown item reference data in that specific section of the data array?
Windows 7 64bit 
Office 2013
Threaded Mode