# Newbie needs a function (how sad)

1. ## 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

2. ## Re: Newbie needs a function (how sad)

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

3. ## Re: Newbie needs a function (how sad)

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

>
>
>

4. ## Re: Newbie needs a function (how sad)

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

> >
> >
> >

5. ## Re: Newbie needs a function (how sad)

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

>
>
>

6. ## Re: Newbie needs a function (how sad)

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

Bob

"tjr" <tjr@discussions.microsoft.com> 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" <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
> > > >
> > > >
> > > >

> >
> >
> >

7. ## Re: Newbie needs a function (how sad)

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

>
>
>

8. ## Re: Newbie needs a function (how sad)

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

--

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

> >
> >
> >

9. ## Re: Newbie needs a function (how sad)

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

> >
> >
> >

10. ## Re: Newbie needs a function (how sad)

I think I figured it out nothere...

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

> >
> >
> >

11. ## Re: Newbie needs a function (how sad)

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

>
>
>

12. ## Re: Newbie needs a function (how sad)

THANK YOU!!! THANK YOU!!! THANK YOU!!! THANK YOU!!!

"tjr" wrote:

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

> >
> >
> >

13. ## Re: Newbie needs a function (how sad)

Pleasure.

--

HTH

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

"tjr" <tjr@discussions.microsoft.com> wrote in message
news:D81B4DB7-B13B-4CC7-9F53-8C8D9CC3DCCE@microsoft.com...
> THANK YOU!!! THANK YOU!!! THANK YOU!!! THANK YOU!!!
>
> "tjr" wrote:
>
> > 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

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

14. ## Re: Newbie needs a function (how sad)

Pleasure.

--

HTH

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

"tjr" <tjr@discussions.microsoft.com> wrote in message
news:D81B4DB7-B13B-4CC7-9F53-8C8D9CC3DCCE@microsoft.com...
> THANK YOU!!! THANK YOU!!! THANK YOU!!! THANK YOU!!!
>
> "tjr" wrote:
>
> > 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

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

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1