and most importantly, coerce the Booleans
SUMPRODUCT(--(A1:A100=DATE(2005;5;5));--(A1:A100<=DATE
(2005;5;9));B1:B100)
--
HTH
Bob Phillips
<Andy B wrote in message ...
Hi
Few ideas:
You have used a semicolon instead of a comma in your formula. Make sure
that
your regional settings are right for using a comma.
Make sure that your 'date' is a proper Excel date.
Make sure your 'numbers' are proper numbers.
You could try something simpler to check out your logic:
=SUMPRODUCT((A1:A100=DATE(2005;5;5));B1:B100)
should return 2300
--
Andy.
"nfbelo" wrote in message
...
Hi,
I'm having this problem:
A B C
05-May-05 2300 -
06-May-05 1500 -
07-May-05 2000 -
08-May-05 4100 -
09-May-05 3200 13100
10-May-05 2300 -
...
I need to SUM periods like from 5 to 9 May in a column C, so I'm using
this
formula:
SUMPRODUCT((A1:A100=DATE(2005;5;5));(A1:A100<=DAT E
(2005;5;9));B1:B100)
The problem is: SUMPRODUCT = 0
am I doing something wrong?
Note that column A formats: DATE 14-Mar-98
Can you help me?? Thanks
|