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
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*";$
=sumif($A$13:$A$15;"=""*"&A12"
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/
following is a solution to the problem
No comments:
Post a Comment