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


2 comments:

  1. Thank you, Yogi!

    That's exactly what I was looking for. Perfect!

    Many hugs and thanks!

    Wenchie

    ReplyDelete
  2. You Are Very Welcome Wenchie ... Now Let Us Keep Googling.

    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete