Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make excel add in one column if conditions are met in ano
For example, I want to say, if anything in column A (from rows 1-20) =1, then
add whatever is in column B for that same row and put it in field G26. Then I want to say, if anything in column A (from rows 1-20) = 2, then add whatever is in column B for that same row and it it in field H26, and so on through, if anything in column A (from rows 1-20) =8, then add whatever is in column B for that same row and put it in field M26. Does anyone know how I can do that?? -- Thanks! Jodie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make excel add in one column if conditions are met in ano
G26:M26 = 7 cells
Try this entered in G26 and copied across as needed: =SUMIF($A1:$A20,COLUMNS($G26:G26),$B1:$B20) -- Biff Microsoft Excel MVP "Jodie" wrote in message ... For example, I want to say, if anything in column A (from rows 1-20) =1, then add whatever is in column B for that same row and put it in field G26. Then I want to say, if anything in column A (from rows 1-20) = 2, then add whatever is in column B for that same row and it it in field H26, and so on through, if anything in column A (from rows 1-20) =8, then add whatever is in column B for that same row and put it in field M26. Does anyone know how I can do that?? -- Thanks! Jodie |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make excel add in one column if conditions are met in
Wow. I'm stunned. It works great! You're right, I meant F26:M26. Thank
you SOOOO much! -- Jodie "T. Valko" wrote: G26:M26 = 7 cells Try this entered in G26 and copied across as needed: =SUMIF($A1:$A20,COLUMNS($G26:G26),$B1:$B20) -- Biff Microsoft Excel MVP "Jodie" wrote in message ... For example, I want to say, if anything in column A (from rows 1-20) =1, then add whatever is in column B for that same row and put it in field G26. Then I want to say, if anything in column A (from rows 1-20) = 2, then add whatever is in column B for that same row and it it in field H26, and so on through, if anything in column A (from rows 1-20) =8, then add whatever is in column B for that same row and put it in field M26. Does anyone know how I can do that?? -- Thanks! Jodie |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I make excel add in one column if conditions are met in
I meant F26:M26.
Just change the reference from $G26:G26 to $F26:F26. =SUMIF($A1:$A20,COLUMNS($F26:F26),$B1:$B20) -- Biff Microsoft Excel MVP "Jodie" wrote in message ... Wow. I'm stunned. It works great! You're right, I meant F26:M26. Thank you SOOOO much! -- Jodie "T. Valko" wrote: G26:M26 = 7 cells Try this entered in G26 and copied across as needed: =SUMIF($A1:$A20,COLUMNS($G26:G26),$B1:$B20) -- Biff Microsoft Excel MVP "Jodie" wrote in message ... For example, I want to say, if anything in column A (from rows 1-20) =1, then add whatever is in column B for that same row and put it in field G26. Then I want to say, if anything in column A (from rows 1-20) = 2, then add whatever is in column B for that same row and it it in field H26, and so on through, if anything in column A (from rows 1-20) =8, then add whatever is in column B for that same row and put it in field M26. Does anyone know how I can do that?? -- Thanks! Jodie |
#5
|
|||
|
|||
Hi this has given me a head start in a formula I am looking for...
I would like certain conditions meet I.e if a cell = a certain name it then adds specific columns and returns an amount... The amount of names at the moment is 10 but this will increase to 300/400 Any ideas? Thanks Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make a cell in Excel "blink" if conditions are met? | Excel Worksheet Functions | |||
How do I make automatic coloring in a cell vth conditions attache | Excel Discussion (Misc queries) | |||
How do I Make a column in excel a check box column | Excel Discussion (Misc queries) | |||
Excel, when column A and B have same name make column C add up in mail merge | Excel Discussion (Misc queries) | |||
How do I make a column in Excel into two columns for only A3-A8 | Excel Discussion (Misc queries) |