Sum IF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to do a SUM IF using multiple if statements. i am getting data from some other sheet from the same file.
The problem is I would be adding data to that sheet often and all the time I have to change the cell reference in the cells where I have done SUMIF. Is there any way I can write any kind of command in or reference with the sum if function so that I don't have to change the cell reference every time
Thanks
 
Hi Aj!

Sounds like you could use a dynamic range name to do this and then
refer to the named range in your SUMIF.

See:
Debra Dalgleish:
http://contextures.com/xlNames01.html#Dynamic
A step by step intro to creating a dynamic range.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
AJ said:
I am trying to do a SUM IF using multiple if statements. i am
Click to expand...
getting data from some other sheet from the same file.
The problem is I would be adding data to that sheet often and all
Click to expand...
the time I have to change the cell reference in the cells where I have
done SUMIF. Is there any way I can write any kind of command in or
reference with the sum if function so that I don't have to change the
cell reference every time
 
Back
Top