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.


For example with a formula such as:

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

WA111211 example


| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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