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.

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

Haytham Amairah's avatar
Haytham Amairah
Silver Contributor
Apr 11, 2018

Hi Enrique,

 

You can do that, but you have to change the data source by adding a new column contains the week number for each date.

 

I've used this formula in the data source's new column to get the week number labels:

="Week "&WEEKNUM(A2,16)&" of the year "&YEAR(A2)

After changing the data source, you can use SUMIF function with a single criterion depends on this new column.

 

Please find the attached file to see that.

 

Hope that helps

Haytham

Resources