Sum IF

[AJ]

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

 

[Norman Harker]

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.

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