Home |
Search |
Today's Posts |
#1
|
|||
|
|||
conditional if based on a word value...
Hi there,
I am fairly new to Excel. What I want to do is this: I have a column named 'Program'. I have another column named 'Amount'. If 'Program' = "Seed" then sum all entries in the 'Amount' column where Program = "Seed". Can I do this in excel? If so, how? Kind Regards, -- Carlee |
#2
|
|||
|
|||
=SUMIF(A2:A500,"Seed",B2:B500)
where cells A2:A500 contain the program names and cells B2:B500 contain the amounts "Carlee" wrote: Hi there, I am fairly new to Excel. What I want to do is this: I have a column named 'Program'. I have another column named 'Amount'. If 'Program' = "Seed" then sum all entries in the 'Amount' column where Program = "Seed". Can I do this in excel? If so, how? Kind Regards, -- Carlee |
#3
|
|||
|
|||
If the "Program" column is Column A, and the "Amount" column is Column B,
then try this: =SUMIF(A:A,"Seed",B:B) -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Carlee" wrote in message ... Hi there, I am fairly new to Excel. What I want to do is this: I have a column named 'Program'. I have another column named 'Amount'. If 'Program' = "Seed" then sum all entries in the 'Amount' column where Program = "Seed". Can I do this in excel? If so, how? Kind Regards, -- Carlee |
#4
|
|||
|
|||
One way:
=SUMIF(Program,"Seed",Amount) In article , Carlee wrote: Hi there, I am fairly new to Excel. What I want to do is this: I have a column named 'Program'. I have another column named 'Amount'. If 'Program' = "Seed" then sum all entries in the 'Amount' column where Program = "Seed". Can I do this in excel? If so, how? Kind Regards, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
Conditional Formatting based on Text within Text | Excel Discussion (Misc queries) | |||
conditional formatting based on column | Excel Discussion (Misc queries) | |||
Conditional formatting based on text | Excel Worksheet Functions | |||
Conditional format (word change) | Excel Worksheet Functions |