Thread: SUMIF by Week.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
GEM GEM is offline
external usenet poster
 
Posts: 90
Default SUMIF by Week.

How can I sum a range of cells, identifing them by week.

For example, I have column B with dates, and colum C has different numbers.
I want to use a SUMIF function on A1 that automatically adds different cells
from column C which are included in this week.

Something like this, =SUMIF(B1:B100,TODAY(),C1:C100) but instead
of TODAY(), I want to use this week.