Forum Discussion

Copper Contributor

Sep 11, 2023

Adding consecutive cells

Hi all, I need to populate the below each week for all of our sites. I'm hoping there is a formula I can use that will pull 7 days of data from one worksheet to this one, without manually adding them...

excel

PeterBartholomew1

Silver Contributor

Sep 11, 2023

AmyInman

Summing the amounts is more commonly encountered than listing them. That would require

= SUMIFS(Amount,
       Category, distinctCategory,
       Date,     ">=" & weekCommencing,
       Date,     "<"  & weekCommencing + 7
  )