TransWikia.com

How to subtract two columns in Google Sheets query?

Web Applications Asked on January 6, 2021

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.

One Answer

For example with a formula such as:

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

WA111211 example

QUERY

Correct answer by pnuts on January 6, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP