# COUNT Question

#### rnkhan

##### New Member
Hi,

I have the following spreadsheet set up in a similar manner:

Amount Commitment
55,000 Y
700,000 Y
2,000 N
----------------------
757,000

For the Commitment column, I would like to add a formula that will calculate the total amount from the previous column only if Commitment is set to "Y". Essentially the end result would be:

Amount Commitment
55,000 Y
700,000 Y
2,000 N
----------------------
757,000 755,000

What would be the formula that I would use? Thank you.

### Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

#### Von Pookie

##### MrExcel MVP
Should be as easy as SUMIF:

=SUMIF(B2:B4,"Y",A2:A4)

#### rnkhan

##### New Member
That works! Thank you!!!!

Replies
0
Views
204
Replies
13
Views
475
Replies
26
Views
786
Replies
2
Views
542
Replies
3
Views
137

1,190,944
Messages
5,983,793
Members
439,858
Latest member
Sarrah91

### 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