Excel =SUM(A1=A1+B1)

S

Shaikh Imtiyaz

Joined
Aug 6, 2017
Messages
1
Reaction score
0
Please help me sort out this problem as I need to use it everyday and it is really a headache if it goes wrong,

I have a target to sell 1500 units (A1) which is calculated on a daily achievement, suppose I achieved 50 units (A4) today and my till date achievement is 500 units (A2), the balance is 1000 units (A3), but what I achieved today should be added to (A2) and deducted from (A3) just by entering a new number in (A4) which is displayed till midnight only, after that this cell (A4) must be blank.

Every effort will be a helpful
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

chart based on incremental difference 3
Run Macro Upon Entering Data into Cell/s 3
Variable SUM range 16
How to average one constant # to variable #s? A1:A2 A1:A3 A1:A4 1
Sum Help 2
Show actual values added instead of cell references? (=A1+A4 showsas =10+2 in cell) 6
How do I add sequential numbers to existing data in excel? 3
excel "IF" function... is this possible ? 0

Top