tezza
Active Member
- Joined
- Sep 10, 2006
- Messages
- 375
- Office Version
- 2016
- 2010
- Platform
- Windows
- Web
Hi all
What's the best way to do the following:
I have a summary tab listing staff names in Col A which needs the total number of hours from four other tabs (if the name exists) in Col C.
Check if the name exists in 4 other tabs under Col A (tab names change each month), if it does then sum the hours from Col C
My formula is getting long and throws up an error if the name doesn't exist.
What's the best way to do the following:
I have a summary tab listing staff names in Col A which needs the total number of hours from four other tabs (if the name exists) in Col C.
Check if the name exists in 4 other tabs under Col A (tab names change each month), if it does then sum the hours from Col C
My formula is getting long and throws up an error if the name doesn't exist.