How to use the result of the formula?

E

E

EvgenyApMr2020-04-21 16:30:29

excel

EvgenyApMr, 2020-04-21 16:30:29

How to use the result of the formula?

Hello!

There are two formulas.

The first =COUNTIF(E5:AH5;"in")*10 sets all cells with text content "in" to 10.
The second formula is custom =SumByColor(H5:AD5;H5) determines the color of the cell and adds only the cells of the specified color.

Question:
How to organize the joint work of these formulas so that the second formula does not add "in + in + in", but "10 + 10 + 10"?

Reply

Answer the question

Answer the question

In order to leave comments, you need to log in

0 answer(s)

Similar questions

E

Evgeny Kotov2019-01-28 23:09:53

Import data from Mysql table to exel table where is cell value criterion? 0Reply

C

Corvinun2016-08-29 16:13:13

How to create a list of random numbers in Numbers tables? 0Reply

K

keslo2014-08-16 20:18:48

How to download files from the Internet according to XLS data? 2Reply

N

Nikolay Khablenko2022-03-22 23:57:46

C#, NPOI, EXCEL Guys, how to add hyperlink to image, picture? in Excel using NPOI C# Or something else? 0Reply

W

wertex2016-09-01 22:31:18

How to populate an excel spreadsheet using php(YII2)? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question