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    Nov 21, 2012
user BasL said: (!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:


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



 following is a solution to the problem