Saturday, August 4, 2012

yogi_Compute Sums Of Numbers In A Column Meeting Multiple Criteria

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

user Wenchie said:(!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 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