Formula and Function

Copper Contributor

I am using SUMIF("Range for Selection", Criteria ,"Choose Value and Add"). when i auto calculate for 100 cell then only want to change choose value range i don't want to change any other value for every cell. but in auto calculation excel changes all three value range and criteria in every next cell can you please help me for this. Like you see in photo that change first ,second and third range all value but i want  to change only third one and fix other two for every cell. can you please help me.Excel.png 

1 Reply

@Hellomri 

Use $ to "fixate" a range:

=SUMIF($C$3:$C$95, $C98. E$3:E$95)