IF cell gets deleted with new entry

martin_br

New Member
Joined
Oct 25, 2020
Messages
3
Office Version
  1. 365
Platform
  1. Windows
I have an allotment, we are handing out keys to other allotmentpeople for entry to the grounds.
I would like to make a sheet that automatically have the data in it ie the number of keys handed our.
I have made an IF formula that saves the number of keys handed out

in Column E i have =IF(F14=B3;E16;"") If the entrance in B3 (B is Column with all garden numbers 1-381 rows) = F14 (Single cell containing the garden number entered when the owner comes to get keys), then the value in F16 (manual entry of keys handed out is added in Column E). But when I enter a new value in F14 the number of keys from the previous entry(garden) dissapears.

Can someone please help me :)
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

McGuilliam

New Member
Joined
Oct 23, 2020
Messages
21
Office Version
  1. 2016
Platform
  1. Windows
Is it possible to post your excelsheet, if needed with fake data? I'm not sure I completely understand your setup.
 

martin_br

New Member
Joined
Oct 25, 2020
Messages
3
Office Version
  1. 365
Platform
  1. Windows
Is it possible to post your excelsheet, if needed with fake data? I'm not sure I completely understand your setup.
how do I upload it. My first time here, and I do not seem to be able to upload it.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,281
Messages
5,600,720
Members
414,401
Latest member
grenona2020

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top