I’ve got a form I am working on that allows me to enter a company or “description” in a text field and search my transactions for all matches. I’d like to add a total to the lookup. I am currently returning, DAT, Desc, Category, Amount. a total for the amount would be great.
=QUERY(Transactions!B1:F,“SELECT * WHERE LOWER© CONTAINS LOWER(’” &G1& “’)”)
Anyone have thoughts on editing this formula to do that?