Hi

In B2:B50 I have dates in the format 27/11/2008. The last date being
31/12/08
In F2:F50 I have £ totals.

There are more than one instance of many dates.
In L2:L36 I have consecutive dates from 27/11/2008 to 31/12/08

I am using the following to acquire the totals for each day but it is
failing, it returns 0 for all entries.

=SUMPRODUCT(--($B$2:$B$50=L2),--($F$2:$F$50))

Help appreciated
Sandy

Hi Sandy

Try this

=SUMPRODUCT(--(B2:B50=L2)*--(F2:F50))


--
If this posting was helpful, please click on the Yes button

Thank You

cheers,









"Sandy" wrote:

Hi

In B2:B50 I have dates in the format 27/11/2008. The last date being
31/12/08
In F2:F50 I have £ totals.

There are more than one instance of many dates.
In L2:L36 I have consecutive dates from 27/11/2008 to 31/12/08

I am using the following to acquire the totals for each day but it is
failing, it returns 0 for all entries.

=SUMPRODUCT(--($B$2:$B$50=L2),--($F$2:$F$50))

Help appreciated
Sandy

Hi Sandy

use this formula instead

=SUMPRODUCT(--(B2:B50=L2),(F2:F50))

It is not necessary to use *


--
If this posting was helpful, please click on the Yes button

Thank You

cheers,





"xlm" wrote:

Hi Sandy

Try this

=SUMPRODUCT(--(B2:B50=L2)*--(F2:F50))


--
If this posting was helpful, please click on the Yes button

Thank You

cheers,









"Sandy" wrote:

Hi

In B2:B50 I have dates in the format 27/11/2008. The last date being
31/12/08
In F2:F50 I have £ totals.

There are more than one instance of many dates.
In L2:L36 I have consecutive dates from 27/11/2008 to 31/12/08

I am using the following to acquire the totals for each day but it is
failing, it returns 0 for all entries.

=SUMPRODUCT(--($B$2:$B$50=L2),--($F$2:$F$50))

Help appreciated
Sandy