Wednesday, November 21, 2012

yogi_WorkAround For Using SUMIF With WildCard * In Google Spreadsheet

                                          Google Spreadsheet   Post  #881
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 21, 2012
user BasL said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/BFUtcad0PEo)
Using jokers and cells in sumif
Hi Guys,

I am working on a spreadsheet and got a question regarding the sumif function. I want to combine a condition from a cel and a joker. In the spreadsheet (see link below) i want to get 70 in the "error" cel.

I tried various formulas like:
=sumif($A$13:$A$15;"*&A12*";$B$13:$B$15)
=sumif($A$13:$A$15;"=""*"&A12"

*"";$B$13:$B$15)

If it is possible to explain why and when the " " and & are used that would be an added bonus for me. I googled for about an hour now and this seems to be a big mystery (at least for me).

Thanks in advance

Regards

Bas

Link:
https://docs.google.com/spreadsheet/ccc?key=0AlinFMGf4J_AdE5JTkl0aXlSNjk0SE9IeFUxby1tTmc
 ----------------------------------------------------------------------------------
 following is a solution to the problem