Newbie needs a function (how sad)

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

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

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

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

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

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