N
nfbelo
Hi,
I'm having this problem:
A B C
05-May-05 1000 -
06-May-05 2000 -
07-May-05 2300 -
08-May-05 1500 -
09-May-05 3600 10400
10-May-05 4100 -
....
I need to SUM periods like from 5 to 9 May in a column C, so I'm using:
SUMPRODUCT((A1:A100>=DATE(2005;5;5));(A1:A100<=DATE(2005;5;9));B1:B100)
The problem is: SUMPRODUCT = 0
am I doing something wrong??
Note that column A format is: DATE 18-Mar-98
Could you help me?? Thanks
I'm having this problem:
A B C
05-May-05 1000 -
06-May-05 2000 -
07-May-05 2300 -
08-May-05 1500 -
09-May-05 3600 10400
10-May-05 4100 -
....
I need to SUM periods like from 5 to 9 May in a column C, so I'm using:
SUMPRODUCT((A1:A100>=DATE(2005;5;5));(A1:A100<=DATE(2005;5;9));B1:B100)
The problem is: SUMPRODUCT = 0
am I doing something wrong??
Note that column A format is: DATE 18-Mar-98
Could you help me?? Thanks