Anthony47
Well-known Member
- Joined
- Mar 29, 2006
- Messages
- 3,844
- Office Version
- 365
- 2010
- Platform
- Windows
Hello everyone.
I tryed using Weeknum as one of SUMPRODUCT matrixes to obtain the weekly sum of a value.
Basically the formula is
A2:A100 contain the date and B2:B100 contain the value i need to sum up; K1 is the weeknumber whose values I am trying to sum.
But I get a #VALUE error, referred to matrix 1.
If I use Weeknum in a standard fashion (eg =WEEKNUM(TODAY())) it is of course Ok.
When I use a similar formula for monthly sums it is ok:
Does it means that WEEKNUM cannot be used in a matrix formula or am I using it in the wrong sintax?
Thank you.
I tryed using Weeknum as one of SUMPRODUCT matrixes to obtain the weekly sum of a value.
Basically the formula is
Code:
=SUMPRODUCT((WEEKNUM(A2:A100,1)=K1)*1,B2:B100)
But I get a #VALUE error, referred to matrix 1.
If I use Weeknum in a standard fashion (eg =WEEKNUM(TODAY())) it is of course Ok.
When I use a similar formula for monthly sums it is ok:
Code:
=SUMPRODUCT((MONTHS(A2:A100)=J1)*1,B2:B100)
Does it means that WEEKNUM cannot be used in a matrix formula or am I using it in the wrong sintax?
Thank you.