Welcome Guest.

2Answers

excel extract specific number sum

Asked by: Carl Scott 110 views Software December 21, 2020

How can excel extract specific numbers to sum up?

For example, the number 89, I want to extract the sum between 60-89, is there a function to extract quickly

2 Answers

  1. +6Votes  

    A1=60

    B1=89

    C1 input

    =SUM(ROW(INDIRECT(“$”&A1&”:$”&B1)) )

    Then, press CTRL+SHIFT+ENTER

    Jimmy Campbell- December 22, 2020 |

  2. +5Votes  

    This mathematical formula can be used

    For example, A1 is 60, A2 is 89

    You require the sum between them to be placed in A3

    Then the formula is

    =(A1+A2)*(A2-A1+1)/2

    Lewis- December 23, 2020 |