=SUM(Filter(H2:H244,(C2:C244=J9)+(C2:C244=J10))). J9=Boston; J10= New York
Results will give us total amount of money made in Boston and New York together.
What will be the result of following formula: =SUM(Filter(H2:C245,C2:C245="Boston"))
Error. Need to explain why.
What will be the result of following formula: =Filter(C2:C245,C2:C245="Boston",C2:C245="Los Angeles")
Error. Need to explain why.
Name three functions which were used in following formula?
SUM, VLOOKUP, IMPORTRANGE
What is the result of the following formula: =SUM(VLOOKUP(E4,A$4:C$16,3,false)+10) ?
40
What will be result of this Formula: =VLOOKUP(E4,A4:B8,2,0)?
Error. Explain why?
What will be the result of following formula: =Filter(C2:C245, (C2:C245="Boston")+(C2:C245="Los Angeles"))
The result will be the column containing values of Boston or Los Angeles in order
What is the result of the following formula, when it's applied to green cell =VLOOKUP(G4,A4:C16,2,false)?
Error. Explain why?