COUNT Question

[rnkhan]

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.

 

[Von Pookie]

Should be as easy as SUMIF:

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

 

[rnkhan]

That works! Thank you!!!!