dynamic sum

Hi, I have a formula in cell D1 Sum(A1+B1-C1) i want the formula to move forward if if insert a column left side so formula move to the E1 and formula will be Sum(B1+C1-D1). What happens here is that A1 drops out and D1 added in the formula. I try with offset function but not working for me

Hello, I have a table where in my first columns is of dates (there will be multiple entries of same date, which I add daily and number of rows increases) and 6th columns has values. these are the values for respective dates. sample is as follows. <tbody> Date Amount 1/1/17 500 1/1/17...

I have a table with multiple years and rows of data. Each record for each year has the same number of rows (3) and the same number of columns (13). The issue is that some years can have multiple records, with different header rows for each record. I would like to sum the 3rd row of each year...

Hi there, I have this certain code that I need to implement. Basically I have to add values in several sheets based on hlookup. However, the names of the lookup tables in each sheet are worksheet-scoped and similar for scalability, and I have no idea how to implement the hlookup function in vba...

I'm trying to create a dynamic sum formula off of a table of data which is then used in pivot tables and pivot charts. What I would like it to do, is show me the summation of values AFTER a filter has been applied. Everything I've tried returns a sum of the entire table (includes hidden cells)...

Hello I have 31 columns in a row as days of the actual month. How I can sum the first 'n' columns in the row, where 'n'=today()-1? Many thanks for tip. Catalin

Hello, I'm trying to sum a range of values selected by a user via a type 8 input box and set it as a variable for later evaluation. Can somebody please help? Thank you, find the vba below: Sub formulacheck2() Dim Y As String Dim X As String Dim R As Range Dim ws As Worksheet Dim N As Long...

In the column A of a sheet I put every month some employees names. In column B I put a number that indicates how much times each employee does a specific task. I another column, say F, I have all the employees names, like that: John Tom Mary George Steve etc. What I want is to get next to each...