Ouch! Please remember that I really don't know what I am doing and this
project that I have created for myself is truly making me insane.
Did the file reach you?

"Bob Phillips" wrote:

> 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" <tjr@discussions.microsoft.com> wrote in message
> news:A7801E23-4D15-4F1A-8AED-639D61E2BA65@microsoft.com...
> > ??SORRY??WHERE
> >
> >
> > "Bob Phillips" wrote:
> >
> > > Yes, feel free. Not the spam spoiler in my email address.
> > >
> > > Bob
> > >
> > > "tjr" <tjr@discussions.microsoft.com> wrote in message
> > > news:2959AD54-A50B-463C-B728-B7E711397512@microsoft.com...
> > > > 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" <tjr@discussions.microsoft.com> wrote in message
> > > > > news:B89319A3-8873-444B-8BAC-75361FEF1658@microsoft.com...
> > > > > > 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" <tjr@discussions.microsoft.com> wrote in message
> > > > > > > news:A0003F2C-9F19-429B-A142-E4AEE525596E@microsoft.com...
> > > > > > > > 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
> > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>
>