Strange problem this...I have followed to the letter differnt methods of
solving this:

3 Columns A, B and C

Column A is in date format DD/MM/YYYY at the moment 17/06/2005
Column B is picked from a list but for now contains just text (i.e-
name of saleman say "Bob")
Column C is currency format and for now just contains just one entry
("£55.00")

What i want is to sum all sales from A for that date if the saleman is
Bob

And this is what i did......

=SUM((B1:B11="bob")*(A1:A11="17/06/2005")*C1:C11)

Remembering of course to press Ctrl+Shift+Enter to get the squiggly
lines for the array.

Nothing. The value i get is "0"

I'm sure i'm missing soomething obvoius here but can't see it.

Anyone able to help????

Thanks,

Chris


--
chris100
------------------------------------------------------------------------
chris100's Profile: http://www.excelforum.com/member.php...o&userid=25166
View this thread: http://www.excelforum.com/showthread...hreadid=386956