If Question

[BrianExcel]

I need an equation that basically says:

If the value in column K = yes, then add the values in column AI together for a sum.

Thoughts?

 

[VoG]

Try

=IF(K1="yes",SUM(AI:AI),"")

 

[T. Valko]

I need an equation that basically says:

If the value in column K = yes, then add the values in column AI together for a sum.

Thoughts?

Try this...

=SUMIF(K2:K100,"yes",AI2:AI100)

 

[schielrn]

maybe?

=sumif(k:k,"yes",ai:ai)

Hope that helps.

 

[BrianExcel]

Thanks That worked!