Forum Discussion

hellomf's avatar
hellomf
Copper Contributor
Mar 01, 2025

Calculate same period in Excel

  Hi everyone, I am trying to use excel to achieve the following but not sure if it something possible. For some reasons, I need it to be in excel. I have a sale sheet with customer's sales and v...
excel
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 04, 2025

If use structured table, perhaps you mean

for current visits

=SUMIFS( [Visit],
   [Customer], [@Customer],
   [Date], ">=" & [@DateStart],
   [Date], "<=" & [@DateEnd]
)

for previous visits

=SUMIFS( [Visit],
   [Customer], [@Customer],
   [Date], ">=" & EDATE([@DateStart], -12),
   [Date], "<=" & EDATE([@DateEnd], -12)
)

Same for sales

Resources