-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Iferror
- Thread starter sburkhar
- Start date
MrKowz
Well-known Member
- Joined
- Jun 30, 2008
- Messages
- 6,653
- Office Version
- 365
- 2016
- Platform
- Windows
Try adjusting your TOTALS formula to the following:
=ROUND(SUM(H6,I6,T6,U6)+ROUND(((SUM(L6,X6)/60)*INFO!$C$10),4),4)
What I believe was happening is that you had a blank cell in any of H6, I6, L6, T6, U6, or X6. When you use the add (+) operator with numbers and blank cells, it will return a #VALUE! error. By replacing those areas with a SUM function instead, it logically treats "" as 0.
=ROUND(SUM(H6,I6,T6,U6)+ROUND(((SUM(L6,X6)/60)*INFO!$C$10),4),4)
What I believe was happening is that you had a blank cell in any of H6, I6, L6, T6, U6, or X6. When you use the add (+) operator with numbers and blank cells, it will return a #VALUE! error. By replacing those areas with a SUM function instead, it logically treats "" as 0.
Upvote
0
Excel Facts
Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
