Forum Discussion

Jamesboden's avatar
Jamesboden
Copper Contributor
Sep 08, 2022

Formula for adding certain cells

Hey Folks   Not sure if this is possible.  I need a formula that will add cells together depending on what is put in another cell.  So if in A it says 1 - I need to add up all the amounts in C tha...
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Sep 08, 2022

Jamesboden 

=SUMIF(A1:A100, 1, C1:C100)

 

Adjust the ranges as needed (they must be the same size)

  • Jamesboden's avatar
    Jamesboden
    Copper Contributor
    Sep 08, 2022
    Hey Hans. Thats great thank you. Would you know how to add a date range to it. so 01/08 to 31/08?
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Sep 08, 2022

      Jamesboden 

      Let's say you have dates in column D. This time, we'll use SUMIFS:

       

      =SUMIFS(C1:C100, A1:A100, 1, D1:D100, ">="&DATE(2022, 8, 1), D1:D100, "<="&DATE(2022, 8, 31))

       

      Instead of including the literal dates in the formula, you can refer to cells - say K1 contains 01/08/2022 and K2 contains 31/08/2022:

       

      =SUMIFS(C1:C100, A1:A100, 1, D1:D100, ">="&K1, D1:D100, "<="&K2)

      • Jamesboden's avatar
        Jamesboden
        Copper Contributor
        Sep 08, 2022
        This is coding I'm trying to use but I'm getting an error
        =SUMIFS(Data!C1:C100,Data!AM1:AM100,"Asda - Cable Maintenance",Data!$E:$E,">="&$S$1,Data!$E:$E,"<="&$T$1)

Resources