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