Welcome Guest.


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  



    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


    Lewis- December 23, 2020 |