yogi_Compute Sums Of Numbers In A Column Meeting Multiple Criteria

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #670   Aug 04, 2012     www.energyefficientbuild.com.


user Wenchie said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/6PI1VFTKxn4)
write formula sum of column that meets multiple criteria
I have a document that lists items and their cost as well as whether they have certain functions.

It is currently set so that Column A lists the items by name, Column B the respective prices, and then there are two extra features of these items listed for column C & D with "Y" or "N" to indicate whether this item contains the respective additional features.

I was hoping to be able to have a formula to cover the sum of the values of Column B for each combination of the two additional features...so for example a sum total of column B for all entries that have a "Y" in columns C & D, one for sum total of Column B for entries where C & D are both "N", and one each for the sum total of B if C="Y" and D="N" and vice versa.

So far the closest I can get is by running a range function which will encompass the result of one column: =SUMIF(C:C,"Y",B:B)

Could anyone help me with how to expand this to encompass both variables?

Thank you in advance for any help. It is greatly appreciated by this lowly noob.

--------------------------------------------------------------------------------------------------

following is a solution to the problem