How to understand a formula in MS Excel?

A

A

Aison2020-04-16 17:48:56

excel

Aison, 2020-04-16 17:48:56

How to understand a formula in MS Excel?

Please help me understand this formula
=SUMPRODUCT(SUBTOTAL(3,OFFSET(C5,ROW(6:24)-5;))*C6:C24*(C6:C24<50))

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)

T

Timur Pokrovsky, 2020-04-16
@Aison

There are many similar formulas here)

Similar questions

S

Sergey Yavin2019-12-16 18:25:45

How to make an Excel spreadsheet from text? 4Reply

A

Andrey Kuznetsov2019-12-16 18:36:38

How to fix url encoding in Excel? 1Reply

D

Denis Mashanov2017-07-21 09:04:24

How to filter a column correctly? 1Reply

T

Tyoma Makeev2015-08-15 14:26:22

How to split a folder with pictures into many folders by CSV (or excel) table? 1Reply

E

Edwin2015-08-18 18:37:03

How to install Plex add-in in MS Excel 2016 on Mac OS X? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question