Forum Discussion
Peterellis0
Jul 25, 2023Copper Contributor
How to Get data from a date range
I need to be able to get data (Week Totals) from the dates Start - End I need the 52 week total and then day rate total. Currently it is a very large sum adding the weekly totals together, but when...
HansVogelaar
Jul 25, 2023MVP
SUMPRODUCT(I26:LC26*(MOD(COLUMN(I26:LC26), 6)=3))