Forum Discussion

Erran Williams's avatar
Erran Williams
Copper Contributor
Nov 23, 2017
Solved

SUMIF Function for a period between two dates

Hi all,   I'm in a bit over my head with this at the moment.. I'm trying to keep track of pallet storage costs. To this end I would like to have cell D2 = sum of the cells in column C (2nd imag...
Formulas & Functions
Need Help
  • Haytham Amairah's avatar
    Haytham Amairah
    Nov 23, 2017

    If so, then you have to use the second example which is based on the cell references, then fill down the target weeks and copy the formula down to calculate these weeks.

     

    This shown in the attached file.

  • Erran Williams's avatar
    Erran Williams
    Copper Contributor
    Nov 23, 2017

    Thank you Haytham for your reply. 

    This solution does work, however it only works for the current week.

    Without me editing the formula for each week in the Pallets In column, is there a way for me to auto-populate the required info?

    • Haytham Amairah's avatar
      Haytham Amairah
      Silver Contributor
      Nov 23, 2017

      If so, then you have to use the second example which is based on the cell references, then fill down the target weeks and copy the formula down to calculate these weeks.

       

      This shown in the attached file.

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

        Hello, thanks for your answer.

         

        Do you know if I can use SUMIF in D2 at the doc that you uploaded?

        I mean the same that you did with SUMIFS but with the rank of week in a single criteria?

         

        Thanks so much for your time

Resources