I want to stack multiple query result in a single array.

Closed last month.

Still new to Google sheets formulas so I’m hoping this community can provide some insight. Here’s a sample sheet (I’ve highlighted the cells of interest) to show the results I’m hoping to get:
https://docs.google.com/spreadsheets/d/1aafxeyQraw-Biw-eG9k-xwhDx6HVYSLmuyD9dFRIDFQ/edit?usp=sharing

I am trying to copy data over from one sheet to another in Google Sheets and I am currently trying to use this query in the second sheet:

I want to create a function that subtracts two cells from each other but stays blank if either of those cells are blank.

I have a table that looks like this:

This question already has answers here: Google spreadsheet importHTML Could not fetch URL (2 answers) Closed 15 days ago. I’m trying to extract RSI(14) value from investing.com into Google Sheets. I tried both =importxml and =importhtml but I’m getting error ‘Couldn’t fetch URL’. Importhtml used to work in past but not working anymore. =importxml(“https://www.investing.com/equities/apple-computer-inc-technical”,”/html/body/div[2]/div[2]/div[2]/div[2]/div[1]/div[3]/div/div[2]/div[2]/div[2]/div/table/tbody/tr[1]/td[2]”) =importhtml(“https://www.investing.com/equities/apple-computer-inc-technical”,”table”,4) […]

I’m using the new Google tables in Google sheets. The name of my table is DB. One of my columns is Type and several columns are names of different properties. One of the options for the Type field is Income. I want to create a named function that sums up all rows with type Income for a given property.

So I don’t know how to explain my problem very well, so I’m going to make an example, I think this is the best way to understand it, but basically I’m trying to return orders that match words in a list, and those words can contain special characters, example below:

I have a sheet with the following setup: