I have a table with dates in one column and payment amounts in another; I'd like to sum the payments based on the week of the year into which they fall. I've tried various approaches using Weeknum() with IFS() and Sumproduct(), but get only #value! errors. I'd appreciate any help you can provide.
Thanks,
Bob A.
Hi Bob,
See attached example. I made a helper column where you first substract the weeknr from the dates. I'm not sure if it's possible without such a column.
On top you see two weeks totalized with the right formula's.
To check yourself filter the week and see the subtotal underneath.
Another way to do this is with a pivot table of course.
Good luck!
Frans
Hi Bob
Using Frans example above but without a helper column.
=SUMPRODUCT((WEEKNUM($A$6:$A$285+0,2)=F2)+0,$C$6:$C$285)
Sunny
