exceltoohard
04-07-2014, 08:52 AM
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 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 from not using much.
quality > speed
good links are good (sharing is caring)
*** ~ 1) Basic Referencing Cell From Another Sheet & 2) Counting Instances Of Anything ~ ***
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 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 from not using much.
quality > speed
good links are good (sharing is caring)
*** ~ 1) Basic Referencing Cell From Another Sheet & 2) Counting Instances Of Anything ~ ***