The function is
=importxml(“https://scryfall.com/search?as=grid&order=name&q=type%3Aaetherborn+color%3E%3DW+%28game%3Apaper%29+legal%3Avintage”,”//strong[1]”)
This should say “0 cards found”

I’m trying to count the number of times either of two cells is not empty/not blank where another cell in the same row contains a specific string.

=ARRAYFORMULA( IF( ISNUMBER(SEARCH(“LST”, A2:A7)), FILTER(REGEXEXTRACT(A2:A7, “[0-9]+”), ISNUMBER(SEARCH(“LST”, A2:A7))) & ” ” & A$1, IF( ISNUMBER(SEARCH(“LST”, B2:B7)), FILTER(REGEXEXTRACT(B2:B7, “[0-9]+”), ISNUMBER(SEARCH(“LST”, B2:B7))) & ” ” & B$1, IF( ISNUMBER(SEARCH(“LST”, C2:C7)), FILTER(REGEXEXTRACT(C2:C7, “[0-9]+”), ISNUMBER(SEARCH(“LST”, C2:C7))) & ” ” & C$1, “” )))) I have this formula and need to make it so I don’t have to do it […]

I have the following QUERY that I am using with IMPORTRANGE in GoogleSheets.

I need help writing a formula that cell’s B7 & C7 will return specific text if cell J7 has specific text. (See below)

In my Google Sheet (see my example sheet here), I have 2 tabs, a Main tab which lists names in A3:A, and a Data Tab in which the names appear somewhere in B1:1, and three columns of data under each name, named SPEND, INCOME, and MISC. A3:A contains Dates in ascending order.

Hi i got a problem where I need to calculate median of a table having two columns i.e..task and count..
Task–count
A1—-23
A1—-20
A2—-15
A2—-10
A2—-
A3—-5
A3—-7
A3—-12

I want to count number of times a specific value shoes up in an exact row. For example, the table in the picture, if I write 501 under ID and add value 3, it should count all threes in second row (id 501)…enter image description here

I want to count number of times a specific value shoes up in an exact row. For example, the table in the picture, if I write 501 under ID and add value 3, it should count all threes in second row (id 501)…enter image description here

Date Income 03/12/2023 $400 03/19/2023 $200 03/21/2023 -$200 04/02/2024 $500 05/18/2024 $350 05/22/2024 -$100 05/31/2024 -$25. I need some guidance on how to use query function to generate running total for above table. The table needs to be grouped by end of the month based on the year (Pivot for the year). thanks in advance. […]