I checked the documentation but couldn't find a way to subtract two columns from each other.

Imagine you have two columns and you want to construct a query that return the subtraction of those two columns.


1 Answer 1


For example with a formula such as:

=query(A:B,"select A-B label A-B 'Profit'")

WA111211 example


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.