can i use sumif formula with my criteria referencing a cell in my sheet?

Brandon Morales

Hi Im trying to create a formula that pulls a sum from different sheet when the criteria matches a cell in my current sheet- is this possible?

i get invalid operation when i try…

Leibel S

Try this:

change to SUMIF to SUMIFS

Change = to @cell=

Leibel S

Try this:

change to SUMIF to SUMIFS

Change = to @cell=

Brandon Morales

that did it- thanks!

Brandon Morales

hey, one more question- is it possible to use a sumif formula for information on the same sheet?

im trying to total the "nested quantity" based on given criteria in the "glass type" column. i want this sum to be reflected in the "projection" column.

any thoughts?