calculate

Is there a way to calculate SUMPRODUCT for an array and a number? E.g. array 1,2,3,4 and a number 10 So it should be 1x10+2x10... Thanks!

Hi all I want to calculate only column B whenever a change is made in column A. Thank you!

Hi, to all members of this great forum. Crossposted : https://chandoo.org/forum/threads/total-by-puestotrabajo-wrong-calculation.41915/ The idea of ​​the table that I present in the file is to distribute a quantity of KG of production in several Puestos de Trabajo, through participations. I...

Need help with a formula to calculate the number of weeks that have passed based on TODAY. I specifically need complete weeks. A1 = 4/29/2018 A2 = ??? (Number of weeks) (Today - A1?) Note: using MS Excel 2013

I have a lot of data in an excel file, and one tab is for data entry only. I want just that sheet to be on calculate manual at all times and have that "Calculate" stay there. Is there any code that will keep that "Calculate" down there? Application.Calculation = xlCaluclationManual does not do it.

<tbody> A B C D E F G H 1 Debt Payment Due Jun Jul Aug Sep Oct 2 Loan $75 1st Y 3 CC1 $25 4th Y 4 CC2 $25 10th Y 5 CC3 $30 15th 6 Internet $75 20th 7 Cell $100 21st Y 8 Ins $100 24th 9 Car $350...

I am trying to make a worksheet that will calculate the averages or a sample taken every 5 minutes constantly. The date column increments in minutes, but comes out with the date attached as well. A sample is below, this is only a few lines:2019-05-21T00:03:40 2019-05-21T08:28:40...

=IFERROR(IF(P4=1,SUM(O5:INDEX($P5:$P$2100,MATCH(TRUE,($P5:$P$2100=1),0)),-1),"")/R2,IF(P4=1,SUM(O5:INDEX($P5:$P$2100,MATCH(TRUE,($P5:$P$2100=1),0)),-1),"")/R2) Would a UDF calculate this faster?

hello i want a formula to calculate sum of repeated text exemple when i put the text its search in table and find the repeated text and calculate the sum like in the picture

Trying to create a measure that an end user could grab and not have to worry about filtering to get the numbers narrowed down appropriately. Sum of gl transactions measure below. Works, but end users would have to know how to manipulate the filters on Acct Fin Class Code, Acct Prop Class...

Hello, I am brand new to excel and need some assistance on how to enter a formula that will calculate the percentage of how many days a week an employee clocked in at 10:05am and anytime before that. <tbody> May 05/01/19 10:06 05/02/19 10:05 05/03/19 10:11 </tbody> <tbody>...

I have a data set that I am trying to calculate a moving average. In the attached picture the Data set is the date started, date ended, and column C is the simply the number of days between those dates. The moving average I am trying get is a rolling 12 month average of Column C shown on a...

Good day, Please help! I need to calculate the highest value per day. I need a formula for the last column. <colgroup><col><col span="3"><col></colgroup><tbody> DATE RATE DATE HIGEST VALUE 2019-05-10 10.0533 10-May 10.0533 2019-05-10 10.0523 13-May 2019-05-13...

Hello, I am having difficulty since I have never used Excel to understand a great deal of what I am reading. I need to count out weeks, 4, 6, 8 depending on what client I am working with from July 15 - December 24 2019. I cannot figure out how to use the excel sheet to make that happen. Can...

I have a list of dates with blank cells in between at various spaces. I need to add 7 days to the date above it no matter it's location (not the last value in the column). Is this the most effective formula I can use to do this? Sometimes it seems to get hung up and not calculate. Here's an...

<colgroup><col width="64" span="19" style="width:48pt"> </colgroup><tbody> Total P 4 P 4 A 0 P 0 P 0 P 7 H 0 P 0 P 0 P 12 A 0 P 0 A 0 H 0 P 0 P...

Hello, I must calculate a Listbox by the numbers of an other Listbox by the function "vlookup". I found many solutions with ListBox and vlookup, but any solution solve my problem. For example ListBox1 has got 16 values. ListBox to must calculate. The Excel-function, which must stand in every box...

I need to calculate a number in a cell based on IF formula. If salary is $20,000,000 over allowed baseline - then penalty is $4.75. At each additional $5,000,000 penalty increases by factor of $.50. So in perfect world a formula to calculate these incremental values. $20,000,000 over allowed...

hello there, i've been stuck with a problem that i cannot resolve. i got a spreadsheet named 2014. On this spreadsheet there's data from cells o3 thru o83 with numbers from 0 thru 99,99 . On another spreadsheet, call it RECAP, i try to calculate how many cells have 0 thru 9,99 on spreadsheet...