# Posts by WTF Canucks

• ## Sum all cells = 100%, if sum is <> than 100%, Error, if all cells blank, Sum = blank

Sum all cells = 100%, if sum is <> than 100%, Error, if all cells blank, Sum = blank
Can't seem to get the formula to show all empty cells in the Total as ""

[TABLE="width: 249"]

[tr]

[TD="colspan: 5"]PRODUCT MIX %[/TD]

[/tr]

[tr]

[td]

PC

[/td]

[td]

XP

[/td]

[td]

LM

[/td]

[td]

PCL

[/td]

[td]

TOT (=100%)

[/td]

[/tr]

[tr]

[td]

5

[/td]

[td]

10

[/td]

[td]

15

[/td]

[td]

70

[/td]

[td]

100

[/td]

[/tr]

[tr]

[td]

40

[/td]

[td]

50

[/td]

[td][/td]

[td]

20

[/td]

[td]

ERROR

[/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td]

ERROR

[/td]

[/tr]

[/TABLE]

• ## Ambiguous name detected: Worksheet_Change - Combining code possible solution

Re: Ambiguous name detected: Worksheet_Change - Combining code possible solution

Hi
They are both for same sheet and thanks for combining. Strange but it worked for a while now it is no longer changing lower into upper case?

• ## Sum all cells = 100%, if sum is <> than 100%, Error, if all cells blank, Sum = blank

Re: Sum all cells = 100%, if sum is &lt;&gt; than 100%, Error, if all cells blank, Sum = bl

Thanks Smallman, you rock.

• ## Ambiguous name detected: Worksheet_Change - Combining code possible solution

Hi All,
Thinking that I have to try and have these combined as I'm getting an error when calculating. Not a programmer so really could use the assistance of the User Community out there.

Compile error:
Ambiguous name detected: Worksheet_Change

• ## Sum all cells = 100%, if sum is <> than 100%, Error, if all cells blank, Sum = blank

Re: Sum all cells = 100%, if sum is &lt;&gt; than 100%, Error, if all cells blank, Sum = bl

NJIMACK,

• ## Sum all cells = 100%, if sum is <> than 100%, Error, if all cells blank, Sum = blank

Sum all cells = 100%, if sum is &lt;&gt; than 100%, Error, if all cells blank, Sum = blank

Sum all cells = 100%, if sum is <> than 100%, Error, if all cells blank, Sum = blank
Can't seem to get the formula to show all empty cells in the Total as ""

[TABLE="width: 249"]

[tr]

[TD="colspan: 5"]PRODUCT MIX %[/TD]

[/tr]

[tr]

[td]

PC

[/td]

[td]

XP

[/td]

[td]

LM

[/td]

[td]

PCL

[/td]

[td]

TOT (=100%)

[/td]

[/tr]

[tr]

[td]

5

[/td]

[td]

10

[/td]

[td]

15

[/td]

[td]

70

[/td]

[td]

100

[/td]

[/tr]

[tr]

[td]

40

[/td]

[td]

50

[/td]

[td][/td]

[td]

20

[/td]

[td]

ERROR

[/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td]

ERROR

[/td]

[/tr]

[/TABLE]

• ## Sum all cells = 100%, if sum is <> than 100%, Error, if all cells blank, Sum = blank

Sum all cells = 100%, if sum is <> than 100%, Error, if all cells blank, Sum = blank
Can't seem to get the formula to show all empty cells in the Total as ""

[TABLE="width: 249"]

[tr]

[TD="colspan: 5"]PRODUCT MIX %[/TD]

[/tr]

[tr]

[td]

PC

[/td]

[td]

XP

[/td]

[td]

LM

[/td]

[td]

PCL

[/td]

[td]

TOT (=100%)

[/td]

[/tr]

[tr]

[td]

5

[/td]

[td]

10

[/td]

[td]

15

[/td]

[td]

70

[/td]

[td]

100

[/td]

[/tr]

[tr]

[td]

40

[/td]

[td]

50

[/td]

[td][/td]

[td]

20

[/td]

[td]

ERROR

[/td]

[/tr]

[tr]

[td][/td]

[td][/td]

[td][/td]

[td][/td]

[td]

ERROR

[/td]

[/tr]

[/TABLE]