esu4236
asked on
#VALUE error
In the attached file, I'm getting a #VALUE error in columns AZ, BG and BL in the "All Master" worksheet. I don't know if there's an erroneous space somewhere in one of the other worksheets that's causing this or what, but I can't seem to get rid of it. Help!!!!
agt-requirements---experts-excha.xlsx
agt-requirements---experts-excha.xlsx
SUM function shouldn't have + signs, use commas like this in AZ6
=SUM(Y6,AG6,AM6,AU6,AX6)
and then you don't need to change anything else. Similarly use SUM in BG and BL like
=SUM(BE6,BF6)
regards, barry
=SUM(Y6,AG6,AM6,AU6,AX6)
and then you don't need to change anything else. Similarly use SUM in BG and BL like
=SUM(BE6,BF6)
regards, barry
ASKER
Is using the plus signs going to cause the #VALUE error though?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Very good, thank you very much Barry!! Appreciate it.
ASKER
=IF(Manager!Y6+RFTC!Y6+Oth
I needed this:
=IF(Manager!Y6+RFTC!Y6+Oth
where I replaced the =0 with =" because sometimes the result was nothing rather than a 0.
And then I had to deselect the option to "Show a Zero in cells that have a zero value."
I think that takes care of it. Anyone see anything else???