Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then formulas
I am looking for an if then formula that will pull text out of one row, and
if that text equals, say, G1, then to multiply all G1's together. Any ideas? Jeanne |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then formulas
If G1 contains a text value, how can you multiply it together? What do
you mean by "pull text out of one row"? Please re-phrase. Pete On Nov 21, 6:58 pm, Jeanne wrote: I am looking for an if then formula that will pull text out of one row, and if that text equals, say, G1, then to multiply all G1's together. Any ideas? Jeanne |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then formulas
"Jeanne" wrote: I am looking for an if then formula that will pull text out of one row, and if that text equals, say, G1, then to multiply the data in other rows. Any ideas? Jeanne |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then formulas
Sorry - Okay, I have a column, in one row is text data, in another row is numerical data. I want a formula that says, if text in B3 =g2, then duplicate numerical data in E3 into cell C22 for a multiplication formula. SO, I want all the numerical data in row E that is from a g2 originator to be multiplied in yet another cell. Does that help? Jeanne "Pete_UK" wrote: If G1 contains a text value, how can you multiply it together? What do you mean by "pull text out of one row"? Please re-phrase. Pete On Nov 21, 6:58 pm, Jeanne wrote: I am looking for an if then formula that will pull text out of one row, and if that text equals, say, G1, then to multiply all G1's together. Any ideas? Jeanne |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then formulas
Not really, because you are mixing up rows and columns - you can't
have a row E ! It might be better to give a small example of what you have and relate it to the exact columns and rows that you are using, so any solutions proposed should work for you without having to make massive changes to the formula to suit your exact layout. It seems as if column B can contain both text and numeric values - so what do you want to happen in cell C22 with the text values in column B that equal the text value in G2? Do you want to multiply the corresponding values from column E? Pete On Nov 21, 7:29 pm, Jeanne wrote: Sorry - Okay, I have a column, in one row is text data, in another row is numerical data. I want a formula that says, if text in B3 =g2, then duplicate numerical data in E3 into cell C22 for a multiplication formula. SO, I want all the numerical data in row E that is from a g2 originator to be multiplied in yet another cell. Does that help? Jeanne "Pete_UK" wrote: If G1 contains a text value, how can you multiply it together? What do you mean by "pull text out of one row"? Please re-phrase. Pete On Nov 21, 6:58 pm, Jeanne wrote: I am looking for an if then formula that will pull text out of one row, and if that text equals, say, G1, then to multiply all G1's together. Any ideas? Jeanne- Hide quoted text - - Show quoted text - |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then formulas
Thanks for your patience - All of the cells in column B designate whether funds are for specific accounts g1, g2, g3. All of the cells in column E designate the amount of a particular deposit in a particular account. then, Cell C22 should have the total deposits into account g1; cell 23 for g2, cell 24 for g3. So, I want to be able to say that for any cell in column b(say B3) that is g1, the corresponding deposit in column E (say E3) will be added with all of the other possible deposits from column B in cell C22. Thanks, Jeanne "Pete_UK" wrote: Not really, because you are mixing up rows and columns - you can't have a row E ! It might be better to give a small example of what you have and relate it to the exact columns and rows that you are using, so any solutions proposed should work for you without having to make massive changes to the formula to suit your exact layout. It seems as if column B can contain both text and numeric values - so what do you want to happen in cell C22 with the text values in column B that equal the text value in G2? Do you want to multiply the corresponding values from column E? Pete On Nov 21, 7:29 pm, Jeanne wrote: Sorry - Okay, I have a column, in one row is text data, in another row is numerical data. I want a formula that says, if text in B3 =g2, then duplicate numerical data in E3 into cell C22 for a multiplication formula. SO, I want all the numerical data in row E that is from a g2 originator to be multiplied in yet another cell. Does that help? Jeanne "Pete_UK" wrote: If G1 contains a text value, how can you multiply it together? What do you mean by "pull text out of one row"? Please re-phrase. Pete On Nov 21, 6:58 pm, Jeanne wrote: I am looking for an if then formula that will pull text out of one row, and if that text equals, say, G1, then to multiply all G1's together. Any ideas? Jeanne- Hide quoted text - - Show quoted text - |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then formulas
So, we are talking about addition now, not multiplication - makes more
sense. Enter this formula in C22: =SUMIF(B$1:B$20,G1,E$1:E$20) I have assumed you have 20 rows of data starting in row 1, so adjust these as necessary and copy the formula down into C23, C24 etc., as required. Basically, the formula says to look through each element of the first array (B1:B20) and if the contents are the same as G1 then add up the corresponding cell from column E. As you copy the formula down, G1 becomes G2, then G3 etc, so you get the totals that correspond to these accounts. Hope this helps (finally). Pete On Nov 21, 10:31 pm, Jeanne wrote: Thanks for your patience - All of the cells in column B designate whether funds are for specific accounts g1, g2, g3. All of the cells in column E designate the amount of a particular deposit in a particular account. then, Cell C22 should have the total deposits into account g1; cell 23 for g2, cell 24 for g3. So, I want to be able to say that for any cell in column b(say B3) that is g1, the corresponding deposit in column E (say E3) will be added with all of the other possible deposits from column B in cell C22. Thanks, Jeanne "Pete_UK" wrote: Not really, because you are mixing up rows and columns - you can't have a row E ! It might be better to give a small example of what you have and relate it to the exact columns and rows that you are using, so any solutions proposed should work for you without having to make massive changes to the formula to suit your exact layout. It seems as if column B can contain both text and numeric values - so what do you want to happen in cell C22 with the text values in column B that equal the text value in G2? Do you want to multiply the corresponding values from column E? Pete On Nov 21, 7:29 pm, Jeanne wrote: Sorry - Okay, I have a column, in one row is text data, in another row is numerical data. I want a formula that says, if text in B3 =g2, then duplicate numerical data in E3 into cell C22 for a multiplication formula. SO, I want all the numerical data in row E that is from a g2 originator to be multiplied in yet another cell. Does that help? Jeanne "Pete_UK" wrote: If G1 contains a text value, how can you multiply it together? What do you mean by "pull text out of one row"? Please re-phrase. Pete On Nov 21, 6:58 pm, Jeanne wrote: I am looking for an if then formula that will pull text out of one row, and if that text equals, say, G1, then to multiply all G1's together. Any ideas? Jeanne- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then formulas
Thank you! Sorry about the confusion. I'll try this and let you know how it
works. Jeanne "Pete_UK" wrote: So, we are talking about addition now, not multiplication - makes more sense. Enter this formula in C22: =SUMIF(B$1:B$20,G1,E$1:E$20) I have assumed you have 20 rows of data starting in row 1, so adjust these as necessary and copy the formula down into C23, C24 etc., as required. Basically, the formula says to look through each element of the first array (B1:B20) and if the contents are the same as G1 then add up the corresponding cell from column E. As you copy the formula down, G1 becomes G2, then G3 etc, so you get the totals that correspond to these accounts. Hope this helps (finally). Pete On Nov 21, 10:31 pm, Jeanne wrote: Thanks for your patience - All of the cells in column B designate whether funds are for specific accounts g1, g2, g3. All of the cells in column E designate the amount of a particular deposit in a particular account. then, Cell C22 should have the total deposits into account g1; cell 23 for g2, cell 24 for g3. So, I want to be able to say that for any cell in column b(say B3) that is g1, the corresponding deposit in column E (say E3) will be added with all of the other possible deposits from column B in cell C22. Thanks, Jeanne "Pete_UK" wrote: Not really, because you are mixing up rows and columns - you can't have a row E ! It might be better to give a small example of what you have and relate it to the exact columns and rows that you are using, so any solutions proposed should work for you without having to make massive changes to the formula to suit your exact layout. It seems as if column B can contain both text and numeric values - so what do you want to happen in cell C22 with the text values in column B that equal the text value in G2? Do you want to multiply the corresponding values from column E? Pete On Nov 21, 7:29 pm, Jeanne wrote: Sorry - Okay, I have a column, in one row is text data, in another row is numerical data. I want a formula that says, if text in B3 =g2, then duplicate numerical data in E3 into cell C22 for a multiplication formula. SO, I want all the numerical data in row E that is from a g2 originator to be multiplied in yet another cell. Does that help? Jeanne "Pete_UK" wrote: If G1 contains a text value, how can you multiply it together? What do you mean by "pull text out of one row"? Please re-phrase. Pete On Nov 21, 6:58 pm, Jeanne wrote: I am looking for an if then formula that will pull text out of one row, and if that text equals, say, G1, then to multiply all G1's together. Any ideas? Jeanne- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
If then formulas
No problem - hope you can get it to work.
Pete On Nov 21, 11:19 pm, Jeanne wrote: Thank you! Sorry about the confusion. I'll try this and let you know how it works. Jeanne "Pete_UK" wrote: So, we are talking about addition now, not multiplication - makes more sense. Enter this formula in C22: =SUMIF(B$1:B$20,G1,E$1:E$20) I have assumed you have 20 rows of data starting in row 1, so adjust these as necessary and copy the formula down into C23, C24 etc., as required. Basically, the formula says to look through each element of the first array (B1:B20) and if the contents are the same as G1 then add up the corresponding cell from column E. As you copy the formula down, G1 becomes G2, then G3 etc, so you get the totals that correspond to these accounts. Hope this helps (finally). Pete On Nov 21, 10:31 pm, Jeanne wrote: Thanks for your patience - All of the cells in column B designate whether funds are for specific accounts g1, g2, g3. All of the cells in column E designate the amount of a particular deposit in a particular account. then, Cell C22 should have the total deposits into account g1; cell 23 for g2, cell 24 for g3. So, I want to be able to say that for any cell in column b(say B3) that is g1, the corresponding deposit in column E (say E3) will be added with all of the other possible deposits from column B in cell C22. Thanks, Jeanne "Pete_UK" wrote: Not really, because you are mixing up rows and columns - you can't have a row E ! It might be better to give a small example of what you have and relate it to the exact columns and rows that you are using, so any solutions proposed should work for you without having to make massive changes to the formula to suit your exact layout. It seems as if column B can contain both text and numeric values - so what do you want to happen in cell C22 with the text values in column B that equal the text value in G2? Do you want to multiply the corresponding values from column E? Pete On Nov 21, 7:29 pm, Jeanne wrote: Sorry - Okay, I have a column, in one row is text data, in another row is numerical data. I want a formula that says, if text in B3 =g2, then duplicate numerical data in E3 into cell C22 for a multiplication formula. SO, I want all the numerical data in row E that is from a g2 originator to be multiplied in yet another cell. Does that help? Jeanne "Pete_UK" wrote: If G1 contains a text value, how can you multiply it together? What do you mean by "pull text out of one row"? Please re-phrase. Pete On Nov 21, 6:58 pm, Jeanne wrote: I am looking for an if then formula that will pull text out of one row, and if that text equals, say, G1, then to multiply all G1's together. Any ideas? Jeanne- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text -- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CELLS NOT CALC FORMULAS - VALUES STAY SME FORMULAS CORRECT?? HELP | Excel Worksheet Functions | |||
lookup formulas dependent upon lookup formulas | Excel Worksheet Functions | |||
automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
Formulas not evaluated, Formulas treated as strings | Excel Discussion (Misc queries) | |||
formulas for changing formulas? | Excel Discussion (Misc queries) |