Sum Data Validation
Closed
zradraco
Posts
2
Registration date
Thursday November 13, 2014
Status
Member
Last seen
November 13, 2014
-
Nov 13, 2014 at 05:19 AM
Blocked Profile - Nov 13, 2014 at 06:14 AM
Blocked Profile - Nov 13, 2014 at 06:14 AM
Related:
- Sum Data Validation
- Display two columns in data validation list but return only one - Guide
- Tmobile data check - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- How to be offline in whatsapp when data is on - Guide
- Data transmission cable - Guide
1 response
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.
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.
