How to use the result of the formula?

E

EvgenyApMr2020-04-21 16:30:29

excel

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

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

In order to leave comments, you need to log in

0 answer(s)