Adding numbers in a column that are links to other sheets
Good morning/afternoon everyone. I am just stumped. Looked throughout the community and I'm not sure what is wrong. I have several columns on what I'm calling a master tracking sheet that pulls info from 32 other individual sheets. I have used the same formula for each of the columns however the first column "open for business" doesn't calculate (add). E.g.:
=SUM([# Bus Cont Complete]2:[# Bus Cont Complete]33) adds up the numbers in the # Business Cont Complete in rows 2 through 33
=SUM([# Cash Flow Complete]2:[# Cash Flow Complete]33) adds up the numbers in the # Business Cont Complete in rows 2 through 33
When I use the same formula: =SUM([Open for Business?]2:[Open for Business?]33) I get 0 even though there are numbers within the column.
Help Article Resources
Check out the Formula Handbook template!