excel-формулы
Sum the column values by shifting the summation range with the specified increment
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?
Account in the range for two conditions
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
Copy the filtered data to another page using = vlookup in excel
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?
Sum the values of a range of cells in columns selected by condition
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
How do I color-select cells where two capital letters [A-Z] meet?
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?
Date and time difference 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?
Excel. Divide the larger number by the smaller number
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.
How to calculate the sum of cells, depending on the values in the neighboring cells?
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.
Updating the formula in OpenOffice Writer
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.
Creating a two-dimensional array in excel
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
Complex condition in Excel (multiple condition if)
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)
Divide the text with the number into two columns (text and number separately)
How can exel divide text with numbers in one column into 2 columns: separate text and separate numbers?
Sample text
Example of split text