help

%3CLINGO-SUB%20id%3D%22lingo-sub-2765558%22%20slang%3D%22en-US%22%3Ehelp%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2765558%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3BA%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BB%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BC%3C%2FP%3E%3CTABLE%20width%3D%22549px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22119.75px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22176.641px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22175.672px%22%20height%3D%2230px%22%3E%23DIV%2F0!%3C%2FTD%3E%3CTD%20width%3D%2275.9375px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22119.75px%22%20height%3D%2230px%22%3E2%3C%2FTD%3E%3CTD%20width%3D%22176.641px%22%20height%3D%2230px%22%3E%23DIV%2F0!%3C%2FTD%3E%3CTD%20width%3D%22175.672px%22%20height%3D%2230px%22%3E%23DIV%2F0!%3C%2FTD%3E%3CTD%20width%3D%2275.9375px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22119.75px%22%20height%3D%2230px%22%3E2%3C%2FTD%3E%3CTD%20width%3D%22176.641px%22%20height%3D%2230px%22%3E%23DIV%2F0!%3C%2FTD%3E%3CTD%20width%3D%22175.672px%22%20height%3D%2230px%22%3E%23DIV%2F0!%3C%2FTD%3E%3CTD%20width%3D%2275.9375px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22119.75px%22%20height%3D%2230px%22%3E2%3C%2FTD%3E%3CTD%20width%3D%22176.641px%22%20height%3D%2230px%22%3E%23DIV%2F0!%3C%2FTD%3E%3CTD%20width%3D%22175.672px%22%20height%3D%2230px%22%3E%23DIV%2F0!%3C%2FTD%3E%3CTD%20width%3D%2275.9375px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22119.75px%22%20height%3D%2230px%22%3E2%3C%2FTD%3E%3CTD%20width%3D%22176.641px%22%20height%3D%2230px%22%3E%23DIV%2F0!%3C%2FTD%3E%3CTD%20width%3D%22175.672px%22%20height%3D%2230px%22%3E%23DIV%2F0!%3C%2FTD%3E%3CTD%20width%3D%2275.9375px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22119.75px%22%20height%3D%2230px%22%3E2%3C%2FTD%3E%3CTD%20width%3D%22176.641px%22%20height%3D%2230px%22%3E%23DIV%2F0!%3C%2FTD%3E%3CTD%20width%3D%22175.672px%22%20height%3D%2230px%22%3E%23DIV%2F0!%3C%2FTD%3E%3CTD%20width%3D%2275.9375px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22119.75px%22%20height%3D%2230px%22%3E2%3C%2FTD%3E%3CTD%20width%3D%22176.641px%22%20height%3D%2230px%22%3E%23DIV%2F0!%3C%2FTD%3E%3CTD%20width%3D%22175.672px%22%20height%3D%2230px%22%3E%23DIV%2F0!%3C%2FTD%3E%3CTD%20width%3D%2275.9375px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22119.75px%22%20height%3D%2230px%22%3E2%3C%2FTD%3E%3CTD%20width%3D%22176.641px%22%20height%3D%2230px%22%3E%23DIV%2F0!%3C%2FTD%3E%3CTD%20width%3D%22175.672px%22%20height%3D%2230px%22%3E%23DIV%2F0!%3C%2FTD%3E%3CTD%20width%3D%2275.9375px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22119.75px%22%20height%3D%2230px%22%3E2%3C%2FTD%3E%3CTD%20width%3D%22176.641px%22%20height%3D%2230px%22%3E%23DIV%2F0!%3C%2FTD%3E%3CTD%20width%3D%22175.672px%22%20height%3D%2230px%22%3E%23DIV%2F0!%3C%2FTD%3E%3CTD%20width%3D%2275.9375px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22119.75px%22%20height%3D%2230px%22%3E2%3C%2FTD%3E%3CTD%20width%3D%22176.641px%22%20height%3D%2230px%22%3E%23DIV%2F0!%3C%2FTD%3E%3CTD%20width%3D%22175.672px%22%20height%3D%2230px%22%3E%23DIV%2F0!%3C%2FTD%3E%3CTD%20width%3D%2275.9375px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22119.75px%22%20height%3D%2230px%22%3E2%3C%2FTD%3E%3CTD%20width%3D%22176.641px%22%20height%3D%2230px%22%3E%23DIV%2F0!%3C%2FTD%3E%3CTD%20width%3D%22175.672px%22%20height%3D%2230px%22%3E%23DIV%2F0!%3C%2FTD%3E%3CTD%20width%3D%2275.9375px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3ECell%20(130)%3C%2FP%3E%3CP%3ESo%20lets%20say%20the%20sum%20of%20the%20columns%20of%20A%20is%2020%20and%20you%20keep%20adding%20to%20it%2C%20but%20you%20want%20to%20divide%20the%20next%20column%20B%2C%20but%20you%20don't%20want%20to%20keep%20manually%20inputting%20the%20cell%20number.%20When%20I%20do%20this%20formula%20%3DSUM(I77%2FI130)%2C%20but%20when%20I%20copy%20that%20formula%2C%20into%20the%20cells%20below%2C%20now%20i%20get%20the%20an%20error%2C%20I%20want%20to%20keep%20the%20I130%20constant%20and%20only%20change%20the%20I77%20........%20is%20that%20possible%20.....%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2765558%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2765607%22%20slang%3D%22en-US%22%3ERe%3A%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2765607%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1160505%22%20target%3D%22_blank%22%3E%40AirportAgent%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EUse%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DSUM(I77%2FI%24130)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

 

 A                         B                                       C

  #DIV/0! 
2#DIV/0!#DIV/0! 
2#DIV/0!#DIV/0! 
2#DIV/0!#DIV/0! 
2#DIV/0!#DIV/0! 
2#DIV/0!#DIV/0! 
2#DIV/0!#DIV/0! 
2#DIV/0!#DIV/0! 
2#DIV/0!#DIV/0! 
2#DIV/0!#DIV/0! 
2#DIV/0!#DIV/0! 

Cell (130)

So lets say the sum of the columns of A is 20 and you keep adding to it, but you want to divide the next column B, but you don't want to keep manually inputting the cell number. When I do this formula =SUM(I77/I130), but when I copy that formula, into the cells below, now i get the an error, I want to keep the I130 constant and only change the I77 ........ is that possible .....?

 

 

1 Reply

@AirportAgent 

Use

 

=SUM(I77/I$130)