Conditional formula

[Martha]

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!

 

[T. Valko]

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)

 

[Martha]

Yes, that worked!! I must have tried every formula but that one. Thank you
so much!!

 

[T. Valko]

You're welcome. Thanks for the feedback!