I'm building a spreadsheet for running the asset list, it calculates monthly depreciation and builds the accounts journal. Its under 1Mb of data.
There are various formulas going on, simple SUM to SUMIFS but very few VLOOKUP.
I entered a SUM to add up a column, the result was £0. ISNUMBER...
Hello!
I would like to get result of 19 in B7 for sum up values where criteria is always banana (A7) but there are multiple ranges(A,E,I) and sum_ranges(C,G,K) which are in every nth column.
A B C D E F G H I J K
1 apple n/a 1 cherry n/a 1 banana n/a 10
2 banana n/a...
Hi everyone.
I have a number spreadsheet with 20 columns /100 rows of numbers. I need to get the sum of the highest 4 CONSECUTIVE numbers of each columns. I have found two formula to get the sum:
=SUMPRODUCT(MAX(D3:D95+D4:D96+D5:D97+D6:D98))
or
=MAX(INDEX(D3:D95+D4:D96+D5:D97+D6:D98,0))...
Hi,
I have a range of numbers at A2:A10. Column B shows the progressive sum (e.g. B2=A2, B3=B2+A3, B4=B3+A4 etc). Column C will either be blank or have a certain text "ABC".
I would like the progressive sum result at column D instead of B with some criteria. I need a formula at D2 which I can...
How can I write a formula that will sum the value from multiple columns using an index match matrix based approach?
The formula below will work when there is only one column that has the "OC_TECH" value, but I want to sum both values if "OC_TECH" occurs as a column header more than once.
for...
I have a list of employees in Column A (some employees are listed multiple times), Column B is the date, and Column H is a points total. Column P I have a unique sorted list of each employee. I would like Column Q to show to sum of points for each employee from column H. I am not sure how to...
Good Morning
We have employee advance and their repayment details in excel.
Each advance having one row with employee no, name, date, advance_amount
Each Receive(Repayment) having one row with Employee no, name, date and repayment_amount
Now we made PIVOT with employee name , sum of...
Hi I am currently using this formula.
=IFERROR(INDEX(Transfers!$J$5:$J$999999,MATCH(A68&$A$61,Transfers!$F$5:$F$999999&Transfers!$H$5:$H$999999,0),MATCH($A$3,Transfers!$E$5:$E$999999,0)),0)
It works great except it does not sum multiple matches it only find the first match in the table. I need...
I'm trying to figure out how to add 1 + 3 and then keep adding three to the sum?
I am curious how to make that work, I've tried all kinds of formulas and now I just want to know to know.
1+3 = 4 then 4+3 = 7
I want to keep it running..
Hi Team,
I want to sum Non Contiguous Columns range. Is it possible sum Below formula in a Single formula.
Need help in R1C1 styles sum.
Range("A6").FormulaR1C1 = "=sum(R[-4]C[0]:R[-1]C[0])"
Range("C6").FormulaR1C1 = "=sum(R[-4]C[0]:R[-1]C[0])"
Range("E6").FormulaR1C1 =...
I'm stuck in my own head - hopefully you can get me out:
I have a budget of $1.6 million dollars, but the state is doing a $2 million dollar budget. Can you please help me with a formula that will show the $1.6M replaced with $2M? Thank you so much in advance and if I need to provide you with...
hi guys,
I'm having a little brain freeze here
I would like sum values in cross table xy based on sum of x and y.
<tbody>
1
2
3
4
1
0.10
0.12
0.25
0.30
2
0.05
0.10
0.32
0.40
3
0.14
0.13
0.10
0.15
4
0.18
0.11
0.16
0.21
</tbody>
For example:
sum values if Column + Row >7.5. We...
I wanna select rows and delete them without using filter.
The reason is that the Model No. is common but customer code is different and sum of required qty. is also different.
So i want to keep only those customer code rows which sum is greater than other customer code rows.
I have a very large...
It is possible to have a formula where i can add a sum to a product? And in my particular case, is it possible that the result of the cell have the sum of a value just only if there are particular conditions?
MY case
=PRODUCT(S15,0.3)
I placed this formula in order to have the result of...
I was wondering if there was a formula that I could use to sum a data file using the below columns as the lookup, I would also like to use another criteria in addition to this.
I.e If any of the numbers in column A appears in raw data file, sum the respective number in another column...
Hello,
I have 5 columns, all of them can contain specific word
6th column is numbers.
Is it possible to take all 5 columns, find if cells contain specific word and sum the number if it does.
For example here I want to sum numbers of red only :
<tbody>
red
blue
yellow
5
blue
red
yellow...
Hello,</SPAN></SPAN>
I need a formula of a VBA that can sum data of column E in the column F when sum reach at 8 restart sum to total 8 again and again. </SPAN></SPAN>
Result sample...</SPAN></SPAN>
<b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px...
Hello everyone!
First time post here and I am hoping someone will be able to answer a couple of issues I have been having with just starting out with VBA on excel. I have a spreadsheet that will have new info every week so the columns will stay the same, but the number of rows will vary...
Hello Everyone,
I have a row of sales data by month and I want to compare the sum of that row with the sum of another row of data from the same date range (ie: April-Sept 2019 total sales to April-Sept 2018 total sales), and then I want the formula to update the range of the sum when we record...
[FONT=Times New Roman][SIZE=3][COLOR=#000000][/COLOR][/SIZE][/FONT][FONT=Calibri][SIZE=3][COLOR=#000000]Hi,[/COLOR][/SIZE][/FONT]
[FONT=Times New...
Welcome to the MrExcel Message Board!
On Saturday, November 16, 2019, the MrExcel Message Board has been migrated to a Shiny New Platform with New Features!
If you are having login problems due to migration, please Contact us.