Sum Data Validation

Registration date
Thursday November 13, 2014
Last seen
November 13, 2014
 Blocked Profile -

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


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.