Monday, August 7, 2017

yogi_Get sum of columns depending on the data in a few other columns Per Specified Pattern

Google Spreadsheet   Post  #2218

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug-07-2017
question by Dan Burton :
https://productforums.google.com/forum/?utm_medium=email&utm_source=footer#!msg/docs/JR2kroEIu48/5e6jRo5XAQAJ;context-place=mydiscussions

Get sum of columns depending on the data in a few other colums

 Hi,

Sorry for the repeat post, I found the post below, which answers what I need to a point. My difference is that I need to look (using this example) for "Anton" in 6 or 7 different columns, not sure how to add the grouping of columns to get my final total. Any help would be greatly received,

Dan
Big Russ said:
Further to Ahab's example, you also need to add information about the column of data you are summing, so assuming you meant your example to be:
    Column B     Column C

    Anton           196,47
    Niclas           1000
    Anton            433,85
    Niclas           130
    Carl              700
The formula should be =SUMIF(B:B,"Anton",C:C) - It is possible to exclude the sum_range as Ahab specified, however I have had mixed results with how the function behaves and tend to explicitly define all aspects of the function for consistent results.