Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
S
S
Sega6662019-05-04 14:22:38
Google Sheets
Sega666, 2019-05-04 14:22:38

Availability in stock - order = balance?

Please tell me how to implement the warehouse function
availability in stock - order = balance
Availability and order are known, you need to compare and take away
the sample at the link https://docs.google.com/spreadsheets/d/1J11tSuJjTC...
5ccd75d7b53f3090310399.png

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

2 answer(s)
Report
N
Noir, 2019-05-04
@PolarBearGG

https://docs.google.com/spreadsheets/d/1nKtIKJVZt4...
maybe I misunderstood something, see

Report
S
Sega666, 2019-05-04
@Sega666

this one =SUMIF(E2:F10; B2; F2:I10)-SUMIF(H2:I10; B2; I2:I10) seems to display the values
​​but it is attached to the cell

Similar questions
I
Ivan Melnikov2019-08-14 13:34:23
Is it possible in google sheets to give a specific email access to view individual columns? 2Reply
T
trazer912021-03-11 15:30:14
We need a macro that, when executed, will copy the string and paste its values ​​below into a free string. How to do it? 2Reply
H
herelanc2019-08-15 18:23:28
How do I set up auto format in a Google Sheets column? 1Reply
M
maxtalanov2019-08-18 17:00:50
How to calculate age from date of birth in google spreadsheet? 2Reply
A
Artem00712021-03-24 15:06:23
How to download a file from docs.google.com/spreadsheets? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question