Formula in individual cells

Ask the Community Formulas
#1

Is it possible to have a formula in seperate cells that reference another column or row in another sheet. IE a sumif.
Thank you