Excel help

%3CLINGO-SUB%20id%3D%22lingo-sub-2348260%22%20slang%3D%22en-US%22%3EExcel%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2348260%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20use%20a%20formula%20to%20pick%20out%20a%20cell%20from%20a%20range%20of%205%20in%20the%20same%20column%20which%20contains%20a%20number%20entry.%20In%20each%20case%20there%20will%20only%20ever%20be%20one%20of%20the%20cells%20in%20the%20range%20with%20an%20entry%20but%20this%20wont%20be%20the%20same%20cell%20reference%20in%20all%20instances%2C%20hence%20why%20I%20need%20excel%20to%20work%20out%20which%20one%20in%20the%20range%20has%20an%20entry.%20This%20cell%20will%20then%20be%20used%20to%20work%20out%20the%20profit%20made%20by%20using%20it%20to%20subtract%20from%20a%20another%20cell.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2348260%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2348385%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2348385%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1051910%22%20target%3D%22_blank%22%3E%40jbaron175%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESimply.%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DSUM(range)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi

 

I am trying to use a formula to pick out a cell from a range of 5 in the same column which contains a number entry. In each case there will only ever be one of the cells in the range with an entry but this wont be the same cell reference in all instances, hence why I need excel to work out which one in the range has an entry. This cell will then be used to work out the profit made by using it to subtract from a another cell.

1 Reply

@jbaron175 

Simply.

=SUM(range)