Sum Data Validation

[Closed]
Report
Posts
2
Registration date
Thursday November 13, 2014
Status
Member
Last seen
November 13, 2014
-
 Blocked Profile -
Hello,

Please someone help me to figure out this problem.
example :

A1 + B1 = C1
A2 + B2 = C2
.
.
.
.
A9 + B9 = C9

If A1 ~ A9 data changed using dropdown list.
Result for C also changed.

How to use data validation option if I want C column total not exceed for some figure with [POP UP] Warning Message.


Thanks in advance for your kindness.

1 reply


Hello,

i'll start you off.

Start with A1 + B1 = C1

Click on C2 and type =SUM(A1+B1) then press enter.

Drag C1 cell down the column (using the square in the bottom right corner of the cell) to apply the formula to all the other cells.

Then you need to look at conditional formatting. Unfortunately i'm at work so cant go into this right now.