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