With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Sunday, October 14, 2012
yogi_Workaround For A WildCard In Use With FILTER SUM(IF And QUERY
I know I could simply delete the condition "Brian!$N:$N=" to achieve a wildcard selection, but I can't in my case because A7, $C$3, and $F$3, are all values that the user selects from drop-downs options. What I'm trying achieve is the formula filtering when the user selects drop-down criteria which includes blanks. For example, criteria could be:
$C$3 = "America"
A7 = * or (blank)
$F$3 = "Q4"
Right now I can't figure out how to allow A7 be blank and the formula still function. Here's an example of what I'm trying to accomplish: