Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
V
V
Vyacheslav Grachunov2015-12-01 21:22:18
excel
Vyacheslav Grachunov, 2015-12-01 21:22:18

How to implement something like the SUMPRODUCT function in Excel?

It is necessary that the values ​​from the first column are multiplied by the values ​​from the second column and added row by row, provided that the value in the third column is greater than zero. Is it possible to do it using Excel functions without VBA?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
V
Vyacheslav Grachunov, 2015-12-01
@Qwentor

Figured it out myself:
=SUMPRODUCT(--($J$3:$J$15>0),($C$3:$C15*$D$3:$D15))

Similar questions
P
Pusont2019-07-04 16:03:54
What formulas are needed and how to do it? 1Reply
A
andreystrelkov2015-02-14 19:05:10
How can I copy-sparse a table / price from a site in Excel? 1Reply
W
wixtransfer2019-07-23 23:51:55
How to make a function for EXCEL from a PHP script? 2Reply
A
asizhuk2019-07-24 18:01:58
nodejs, exceljs. Checking if merged cells intersect horizontally? 0Reply
A
Andrey Demidenko2015-02-23 15:19:51
Which gem to use to parse an excel file into an Active Record object? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question