excel-формулы

There is the following task: Column A contains several thousand numbers. It is necessary to enter the sum of ten cells of co ... 1:A20) B3 = СУММ(A21:A30) , etc. Can you tell me if this can be done by a formula in the table itself, and not by a macro?

1st column - a list with duplicate values (text). 2nd column - values (numbers). 3rd column - desired values. Is it possib ... di.sk/i/7ksyS2FjrER75A ААА 0 1 ААА 4 1 ААА 0 1 БББ 0 0 БББ 0 0 ССС 0 3 ССС 1 3 ССС 3 3 ССС 0 3 ССС 1 3

There is a workbook with a list of students who have taken / failed courses. Passed - "OK", failed - "NO". You need to fi ... have passed a certain course and copy them to another sheet. How can this be done using the =VLOOKUP and/or = IF formula?

I can't find a solution for the following problems: 1) how to sum all the array values that are located at the intersection ... ut the complex design on my own. Link to the file itself: https://drive.google.com/open?id=1B42T65A5ALWQyq3K-V7sKzWRfPU4Vt0S

I have sheets in Excel in which some of the cells contain pairs of capital letters [A-Z]. I need to highlight all these cells in color. How can I do this using Excel? Or how to enable regular expressions in excel?

How to calculate the date and time difference in excel? If you calculate the difference 2018-01-09 15:24:05 and 2018-01-08 2 ... ng counts as it should and outputs only the difference in time, and if there is a difference exceeding 24 hours or one month?

The problem is as follows: there are three cells, each with a numeric value(in the first cell - the first number, in the seco ... s in the first and second cell and divide the larger number by the smaller one, and the result in the third cell is recorded.

Can you tell me how to calculate the sum of all the cells that have additional information on the right? For example, to calculate how much is spent on food.

There is a table in OpenOffice Writer (not Calc). In one of the cells there is an amount that was calculated by the formula. ... edit the entered formula? How do I divide the result (sum) by 8? PS: I can't Google it, everything comes across about Calc.

There is a source array, where each column is a year I have a parameter (for example N) that specifies from which year the ... red lines on the same sheet Preferably with formulas, but also with a macro, it will be interesting to see, if not difficult

There is a main table: columns A and B, in column B there are data, for example 001230, 001273, 001479, 000720, you need to ... functions of the VPR, If the CONDITION is not present, there is also no possibility to reinstall the office to a normal one)

How can exel divide text with numbers in one column into 2 columns: separate text and separate numbers? Sample text Example of split text