Try again.

If you open a post by anyone, and then click on the name in the from box,
you will see the email address. Mine is adulterated as a basic protection
mechanism, but my signature tells you what to do.

But to spell it out, post it to

bob dot phillips at tiscali dot co dot uk

do the obvious with that.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"tjr" wrote in message
...
??SORRY??WHERE


"Bob Phillips" wrote:

Yes, feel free. Not the spam spoiler in my email address.

Bob

"tjr" wrote in message
...
CAN I SEND YOU A COPY OF PART OF THE WORKSHEET?
I am completely at a loss.
tjr


"Bob Phillips" wrote:

I have just tested them both again, and they work fine.

Which did you use, what do you have in C1:C100 (examples of the
data),
and
what in Y1

--
HTH

Bob Phillips

"tjr" wrote in message
...
Now I have a #NUM! error but at least have a valid function, any
ideas?
Thanks

"Bob Phillips" wrote:

if you have 1 in a cell, say Y1

=SUMPRODUCT(--(A1:A100="WalMart"),--(MONTH(C1:C100)=Y1),F1:F100)

or if you have the text January in Y1, then


=SUMPRODUCT(--(A1:A100="WalMart"),--(TEXT(C1:C100,"mmmm")=Y1),F1:F100)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"tjr" wrote in message
...
I am trying to create a function in a checkbook register type
workbook
that
will do the following:
if name in column a = x and date in column c = y then add the
numbers
in
column f that pertain to both x and y.
I am trying to break down monthly spending at specific
places - as
in -
walmart purchases in january.
Is this possible?
Thank you for any assistance