Home |
Search |
Today's Posts |
#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
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
??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 |
#8
|
|||
|
|||
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" 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 |
#9
|
|||
|
|||
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" 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 |
#10
|
|||
|
|||
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 |
#11
|
|||
|
|||
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" 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 |
#12
|
|||
|
|||
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" 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 |
#13
|
|||
|
|||
Pleasure.
-- HTH RP (remove nothere from the email address if mailing direct) "tjr" wrote in message ... 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" 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to list unique values | Excel Worksheet Functions | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
change function variable prompts?? | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions |