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

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

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

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