Conditional formula

M

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

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)
 
M

Martha

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