Forum Discussion

Enrique García Peña's avatar
Enrique García Peña
Copper Contributor
Apr 10, 2018

RE: returning multiple results from a single criteria

Hello, someone can help me please. I want to use a rank in a single criteria, for example: I have a list of years since 1900 to 2018 and I need to take the values from 1990 to 1999 in SUMAR.SI(A2:A39,...
Formulas & Functions
Enrique García Peña's avatar
Enrique García Peña
Copper Contributor
Apr 10, 2018

Actually I want to do this SUMIFS(B2:B38,A2:A38,">1990",A2:A38,"<1999") but using a single criteria in SUMIF(A2:A38,"single criteria 1990:1999",B2:B38)

  • Wyn Hopkins's avatar
    Wyn Hopkins
    MVP
    Apr 10, 2018

    Hi Enrique García Peña

     

     

    You've accidentally tagged your question onto someone else's question. Could you remove your questions from here and post them via Start New Conversation. 

     

    • Enrique García Peña's avatar
      Enrique García Peña
      Copper Contributor
      Apr 10, 2018

      Sorry, I don't know how remove my questions

      • Wyn Hopkins's avatar
        Wyn Hopkins
        MVP
        Apr 10, 2018
        You should be able to click on the downward point arrow in the top right corner and select Delete