Formula

[Guest]

I am using the following formula
=SUMIF(A1:A10,C1,B1:B10

I want to be able to change the 'C1' part of the formula but keep everything else the same and use the formula across many cells. When I cut and paste, excel updates the cell range automatically

Is there way to keep those ranges static

Thanks!!!

 

[Robert Rosenberg]

Use...

=SUMIF($A$1:$A$10,C1,$B$1:$B$10)

Where $ means absolute (frozen) cell references and won't change when
copied.
_______________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com

I am using the following formula:
=SUMIF(A1:A10,C1,B1:B10)

I want to be able to change the 'C1' part of the formula but keep

everything else the same and use the formula across many cells. When I cut
and paste, excel updates the cell range automatically.

 

[Tim]

Try using
=SUMIF($A$1:$A$10,C1,$B$1:$B$10)

-----Original Message-----
I am using the following formula:
=SUMIF(A1:A10,C1,B1:B10)

I want to be able to change the 'C1' part of the formula

but keep everything else the same and use the formula
across many cells. When I cut and paste, excel updates
the cell range automatically.

 

[Guest]

There are 2 ways dependin on what you are trying do.

To keep the cell reference same while using fill function,
place a '$' symbol. like '$A$1'. if placed before
either 'A' or '1', it will keep only that valve constant.

If you are cutting and pasting it somewhere else, to get
the same range and cell reference, you have to make sure
you copy the formula from the formula bar and paste it by
either after double clicking in the cell you want the
formula in or by going to that cell and pasting it in the
formula bar.

hope this help

-----Original Message-----
I am using the following formula:
=SUMIF(A1:A10,C1,B1:B10)

I want to be able to change the 'C1' part of the formula

but keep everything else the same and use the formula
across many cells. When I cut and paste, excel updates
the cell range automatically.

 

[Guest]

That did it...THANK YOU SO MUCH!!

----- Beck wrote: ----

I am using the following formula
=SUMIF(A1:A10,C1,B1:B10

I want to be able to change the 'C1' part of the formula but keep everything else the same and use the formula across many cells. When I cut and paste, excel updates the cell range automatically

Is there way to keep those ranges static

Thanks!!!