gymwrecker
Active Member
- Joined
- Apr 24, 2002
- Messages
- 394
- Office Version
- 365
- Platform
- Windows
- MacOS
Is there a better way (formula) to obtain percentage when linking several tabs? I tried the below formula dividing by 12, which is the number of tabs/individuals that I have, but it's not returning an accurate %...
=SUM('Mr. Doe'!F5,'Mr. Snuffy'!F5,'Mrs. Smith'!F5,'Mr. Preacher'!F5,'Ms. Biden'!F5,'Mr. Lopez'!F5,'Mr. Torres'!F5,'Mrs. Rowe'!F5,'MAJ Farmer'!F5,'1LT Hester'!F5,'SFC Jessop'!F5,'SSG '!F5)/12
=SUM('Mr. Doe'!F5,'Mr. Snuffy'!F5,'Mrs. Smith'!F5,'Mr. Preacher'!F5,'Ms. Biden'!F5,'Mr. Lopez'!F5,'Mr. Torres'!F5,'Mrs. Rowe'!F5,'MAJ Farmer'!F5,'1LT Hester'!F5,'SFC Jessop'!F5,'SSG '!F5)/12
Last edited by a moderator: