M
Maxwell
Sometimes when I write a 'Sumif' formula, I pull from
separate workbooks or worktabs. Here is the issue...
usually my sumif formula will look like this (correct
way)...
=Sumif(Sheet2!$a:$a,$z2,Sheet2!$b:$b)
If you look at "$z2" it is the cell I want pulled.
sometimes when I write this formula it does this...
=Sumif(Sheet2!$a:$a,Sheet1!$z2,Sheet2!$b:$b)
the "$z2" is now "Sheet1!$z2".
Both ways work but now if I sort it, the ranges are all
messed up for the "$z2" depending on the row it is sorted
on.
How do I make it so that when I click on a cell "z2" that
it does NOT come up as "Sheet1!$z2".
It's wierd...sometimes it doesn't pull the sheet name and
sometimes it does. Am I doing something wrong?
Please help
separate workbooks or worktabs. Here is the issue...
usually my sumif formula will look like this (correct
way)...
=Sumif(Sheet2!$a:$a,$z2,Sheet2!$b:$b)
If you look at "$z2" it is the cell I want pulled.
sometimes when I write this formula it does this...
=Sumif(Sheet2!$a:$a,Sheet1!$z2,Sheet2!$b:$b)
the "$z2" is now "Sheet1!$z2".
Both ways work but now if I sort it, the ranges are all
messed up for the "$z2" depending on the row it is sorted
on.
How do I make it so that when I click on a cell "z2" that
it does NOT come up as "Sheet1!$z2".
It's wierd...sometimes it doesn't pull the sheet name and
sometimes it does. Am I doing something wrong?
Please help