Help!!

[Kaza153]

I am a newbie!!

I have created a spreadsheet and need a little bit of help.

I have 2 worksheets on 1 workbook

Sheet 1 = Blank Form
Sheet 2 = Central Sheet

basically... (hahaha)
I need the sum of Blank Form H8 to equal onto Central Sheet B2 on the condition that Blank Form C6 = Mike & H6 = Jan-10 then lock data to that cell (as when the data from blank form is deleted/changed the information stays the same).

I have managed to get the sum to transfer with
=SUMIF('Blank Form'!C6,"Mike",'Blank Form'!H8)

however when i clear the data out from Blank Form Central Sheet B2 is then reset.

Please Help!
Thanks

 

[Kaza153]

Many Many Thanks

It is working a treat!