Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

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


Use $ to "fixate" a range:

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