1) worksheet A sheet1 has a number in cell a1 on sheet2, you want to reference the a1 cell in sheet1. you want to do this in sheet2 on cell a1. you want "100-{sheet1a1}" 2) worksheet B on sheet100, you want to count how many cells has something in it from cell a2 to a200 cell can be empty can you do this with text in cells? or numbers? or a mix? you want to know how to do numbers though. ~ end ~ sorry don't know what to google, don't use this function in excel much.. googling is very messy, confusing, and scattered. please explain clearly. please do not use excel terms. won't understand. excel 2013 ~ extra ~ an excel cheatsheet for this would be helpful since i'll forget pretty soon from not using that function or whatever much. quality > speed good links are good (sharing is caring) *** ~ 1) Basic Referencing Cell From Another Sheet & 2) Counting Instances Of Anything ~ ***