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 ~ ***

Edited April 7, 201412 yr by office13broken

I am not sure to understand fully the question.
WorksheetA - Sheet1 has in A1 42 (a number)
WorksheetA - Sheet2 has in A1 =100-(Sheet1!A1) and you will see 58
WorksheetB - Sheet100 has WHERE? a cell counting the amount of values in range A2 to A200 OF WHICH Worksheet/sheet?
There are three main "counting" functions in Excel:

COUNT() <- will count ONLY numbers

COUNTA()<- will count BOTH numbers and texts

COUNTBLANK() <- will count ONLY empty cells

See if the attached example helps.

jaclaz

Counttest.zip

Edited April 7, 201412 yr by jaclaz