calculations

Hi All, I've encountered an issue that I can't seem to resolve where my SUMIFS formulas are not carrying out the calculations as requested? This is the code I'm using...

Hello. Is there a way to have calculations set for manual if the user selects a particular worksheet/tab in the file (i.e tab name is "Example A") & when the user selects any other tab/worksheet in the same file, calculations are set for automatic? Also is there a way to display in a cell if...

Afternoon, I have a simple problem but one which I am not yet experienced / understanding on how to create it. I do alot of calculations in a source workbook, this data then feeds into the Main workbook (where the code is contained). How do I retain each calculated value in the Source workbook...

There must be a technique of which i am ignorant to preserve the addresses or the formulas a range name refers to. A workbook has been returned from coworkers with unexplained #REF # errors in some range name addresses. So, how is this best fixed, that is, where and how should this...

I have a workbook that has many worksheets. One of these worksheets is named "Plot" which graphs data. Right now, whenever I do an entry on the worksheet "Main", I run a macro called "Update" which does all of the calculations needed and updates the workbook. This is a slow process and takes...

Hi All, I have created a form in access through which I enter data to a table. I have created also some fields in the form that they do some calculations and I want to enter these calculations to the table and I want each time I go back and forth to the records through the form to see the...

I have a workbook that needs to be set to Manual calculations with the "Recalculate before saving" button unchecked due to the data warehouse add on. This is exclusive to this file. However, I opened another file and this setting migrated to this workbook and now when I open ANY file, this...

Running into a strange bug. I have a sheet that will cause Excel's GUI to completely lock up (as if ScreenUpdating was turned off) if I unhide any rows while calculations are enabled. What makes this strange is that this sheet is relatively rudimentary with only basic INDEX/MATCH formulas...

Hello I would like some advice. On one of my sub I have over 25 different calculations in VBA that get used to create a value. I am having problems where if one of the calculations is divided by zero then I get an error message. At the moment I am using the on error resume next. But this does...

Is it possible that I can enter a numeric value and a date in the same cell, but only the numeric value is taken for calculations. say, Cell A1 has "100", and Cell B1 has 25 - 03-09-17 in it . What I need in cell C1 is 100-25 = 75. (the result 75 only). 25 is the sale done on 03-09-17, and now...

Colleagues, I have faced the following issue: I need to perform similar calculations on different inputs, saving the output. Is there any way to use Excel workbook as framework for those calculations? For example, I need to perform A + B calculation. I created workbook WB1, which contains on...

I am building a pivot table where I need to show the COUNT OF FIELD divided by 2. Any ideas how I might to about that?

Good day Will others be able to ratify this observation? I've been writing Excel based software for years and have ignored speed of computations (brushed it under the carpet) until recently when even the 2 or 3 seconds the algorithms took seemed too long. I've discovered that if I set the...

I apologize for the long title. Here is what I am try to do. <tbody> Company Name Computer Name Connection Date Prior Activity Date Completed Date Penguins1 lab1 7/24/2017 7/24/2017 7/24/2017 Bears Inc lab2 4/23/2017 4/23/2017 1/18/2017 Bears Inc lab3 7/24/2017 7/24/2017 7/10/2017...

For a class I have a set of data that gives actual sales for each day. I currently have a Pivot table of the sum of those actuals and I want to make another one daily actuals. I cannot just create a calculated field because it divides the number of days by each transaction and I don't want...

<tbody> A B C D E F G H I Material Apr Volume Price April revenue May Volume Price May Revenue Volume Total Total Revenue 1 X 10 1.00 10.00 5 1.00 5.00 15 15.00 2 Y 1 2.00 2.00 2 2.00 4.00 3 6.00 </tbody> I am using a pivot table in which total monthly volumes are calculated. I am...

Hi, I have a date and time column in Column A and a value in colmun B. I need to take the value 150 rows down e.g row 151 and minus the value in B2. I then need to repeat this for every 150 rows, so the next calculations would be (B301-B152), then (B452 - B302). Is there a formula I can just...

why is this not calculating? =IFERROR(SUM('Game Data'!$E$2:$E$10000,$A$1,'Game Data'!$H$2:$H$10000,"=>1"),"") "E" is list of names that match "A1" and "H" is numbers greater or equal to 1

I have a data model built in Power Pivot with a few tables connected and I am trying to do a simple formula based on a few conditions. Basically calculate this formula if Scenario 1, 2, and 3 are true. Below is a view of the Error: The way it is written is like a nested IF Statement, but I am...

Hello, I am trying to keep track off time off for employees and I need the calculations on my spreadsheet to calculate only up to 59 and then once 60 is hit, I need it to calculate to 1 hour. My current spreadsheet is calculating up to 99 before hitting the 1hour. I hope this makes sense...