??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