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