# If Question

#### BrianExcel

##### Well-known Member
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?

### Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
Try

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

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)

maybe?

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

Hope that helps.

Thanks That worked!

Replies
13
Views
256
Replies
2
Views
133
Replies
13
Views
341
Replies
1
Views
98
Replies
7
Views
241

1,216,515
Messages
6,131,111
Members
449,620
Latest member
MatXm

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back