Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formula
Is there a way to create a formula for a group of cells? I am wanting it to
give me the sum of all the cells in Column F that correspond to the same row from Column A if Column A has a certain value in that row's cell. There is over 200 rows of information in these columns. Any help would be greatly appreciated! -- Martha |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formula
if Column A has a certain value in that row's cell.
What is that value? If it's a number like, say, 10: =SUMIF(A1:A200,10,F1:F200) If it's a text string like, say, Yes: =SUMIF(A1:A200,"Yes",F1:F200) -- Biff Microsoft Excel MVP "Martha" wrote in message ... Is there a way to create a formula for a group of cells? I am wanting it to give me the sum of all the cells in Column F that correspond to the same row from Column A if Column A has a certain value in that row's cell. There is over 200 rows of information in these columns. Any help would be greatly appreciated! -- Martha |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formula
Yes, that worked!! I must have tried every formula but that one. Thank you
so much!! -- Martha "T. Valko" wrote: if Column A has a certain value in that row's cell. What is that value? If it's a number like, say, 10: =SUMIF(A1:A200,10,F1:F200) If it's a text string like, say, Yes: =SUMIF(A1:A200,"Yes",F1:F200) -- Biff Microsoft Excel MVP "Martha" wrote in message ... Is there a way to create a formula for a group of cells? I am wanting it to give me the sum of all the cells in Column F that correspond to the same row from Column A if Column A has a certain value in that row's cell. There is over 200 rows of information in these columns. Any help would be greatly appreciated! -- Martha |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formula
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Martha" wrote in message ... Yes, that worked!! I must have tried every formula but that one. Thank you so much!! -- Martha "T. Valko" wrote: if Column A has a certain value in that row's cell. What is that value? If it's a number like, say, 10: =SUMIF(A1:A200,10,F1:F200) If it's a text string like, say, Yes: =SUMIF(A1:A200,"Yes",F1:F200) -- Biff Microsoft Excel MVP "Martha" wrote in message ... Is there a way to create a formula for a group of cells? I am wanting it to give me the sum of all the cells in Column F that correspond to the same row from Column A if Column A has a certain value in that row's cell. There is over 200 rows of information in these columns. Any help would be greatly appreciated! -- Martha |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Formula, Conditional Formula Needed | Excel Discussion (Misc queries) | |||
Conditional Formula to indicate Formula in cell | New Users to Excel | |||
Need Conditional Formula | Excel Worksheet Functions | |||
conditional formula? | Excel Discussion (Misc queries) |