Search code examples
if-statementgoogle-sheetsformula

Google Sheets - make a list of the names in column A where column E is greater than zero

I have a simple Google Sheets spreadsheet of output from Quickbooks on account aging. Column A has a list of customer names, Column E has a number if they are past due. What I want to get is a list of the names of all the people who owe more than nothing.

This formula gets me a list of the dollar amounts they owe:

=query(Data!A6:F241, "Select E Order by E Desc limit 300")

But I can't seem to get a list of the names from column A if E > 0 (or empty). What clue am I missing?

Solution

  • You may try:

    =QUERY(Data!A6:F241, "SELECT A WHERE E > 1 ORDER BY E Desc limit 300", 0)

    Reference