Stop and start counting in different cells

[Turbos]

Hi All

i have generate a very simple sales tracker Spreadsheet that counts sales made daily compared to target for the day and giving me a total at the end of the day if target was made or not if it was it amount will be a + and if not, the amount will be a -

so the sheet starts at day one and gets updated daily with the new overall sales total telling me where i stand for that day regarding the target

at the bottom of the sheet i have 4 different totals with the ref as below

Cell | Heading | Total
B31 Target R690,060.00
B32 Current R640,173,59
B33 Needed R-49,886.41
B34 Over R0

so what i am looking to do is when the total in Row B32 reaches the total in Row B31 the Needed amount in Row B33 will reach zero and then what ever gets invoiced after this must then start adding in Row B34 showing that i have reached target and am now going into over Amount required for the month.

please could you let me know what formula i would need to use to do this

 

[Sergius]

Hello! Why don't you provide data in the form of a table? How are data entered, how is it believed?

 

[Turbos]

TOTAL NEEDED FOR MONTH END
TARGET	R690 060,00
CURRENT	R640 173,59
NEEDED	-R49 886,41
OVER

hi Sergius i am having trouble to upload the Mini-sheet for you too see is there anyother way i can do this for you

 

[Peter_SSs]

i am having trouble to upload the Mini-sheet

Welcome to the MrExcel board!
See if something here helps with that.

 

[Turbos]

Hi Peter

i did try download the xl2bb after extraction i added to my add-inns on excel and then it says this file type is not supported in protected view.

please excuse me in not really a MS Office boff

i have downloaded the file and extracted it for the second time still same thing

 

[Peter_SSs]

then it says this file type is not supported in protected view.

Please follow the link that I gave you above and carefully read that thread. Try what is suggested there.

 

[Turbos]

ok so i have it in my ribbon but i dont have all the functions only mr excel message board capture rage but this is grey cant select and help not sure if ive done something wrong

 

[Turbos]

could i perhaps dm you in anyway or perhaps post a cloud link to the file ?

 

[Peter_SSs]

k so i have it in my ribbon but i dont have all the functions only mr excel message board capture rage but this is grey cant select and help not sure if ive done something wrong

The link that I gave you in post #2 here is all about that. You have to make sure the file is unblocked and that it is in a 'Trusted location'. Check that thread again, especially post #3 by smozgur.

could i perhaps dm you in anyway or perhaps post a cloud link to the file ?

dm for this is not permitted - see #4 of the Forum Rules

You can upload a sample file and provide a link but note that many of the helpers here choose not to download files from other sites or, due to security restrictions at their workplace, are unable to download such files. The best option in most cases is to use XL2BB

 

[Turbos]

Hi All

I am just not coming right with XL2BB, just want to thank everyone for their responses and help, i will try come right on my own my apologies if I have wasted anyone's time, thank you anyway