Hello I need help summing data in a column if the range of columns falls on a certain day. See below for an example of my Gantt spreadsheet. It is divided into 8 hour days. The jobs are on the left side "Y" axis and their progress is depicted in each row. To the right of the job are the...
I have a large population (30k+) of amounts which contribute to the total amount in another table. I was able to pull the two data-sets together, so I can see in one table the whole amount and all of the individual amounts. The issue is that for a given unique identifier (e.g., 12345)...
It is the end of Friday and my Brain just mushy. :banghead:
Here is what I am trying to figure out.
At work we have machines that are using raw materials.
Some of them only uses 1, others 2,3, 4 blend of raw materials.
Each machine uses different amount from each material...
I have a very simple formula:
The values in Column A are being pulled from another sheet in the same workbook and are correct. I've checked for any errors (like extra spaces) in Column C. Instead of summing my results, I keep getting 0.
I tried pasting...
I am working on a project that has a sheet for each week in the year. Within each sheet is varying employee information. On the last "Total" sheet I need it to search for the ID listed in the A column in every worksheet, when found it needs to look at the L column of the same row add it together...
Say I have the following chart (See below) and I'm trying to sum the regions that have product overlap. What type of SumIf or SumProduct formula could I use to accomplish this task?
Hello the best excel, MREXCEL!
I have two columns, first is numbers, second is text.
I have long sumifs formula, it gets job done, but is it possible to shorten formula?
I have a fixed asset register set up as follows:
Cell A1 date
Col A - Location
Col N to Y - Jan to Dec. Each column contains the monthly depreciation value for each asset.
I need to do a sum based on the location, but I need the sum range to change to give me the YTD values. so for...
I need to sum a large data set based on a name and a date. I want the total of Carl's spending in 2014. The answer should be $20. I'm trying to use a sumif...
For this Google spreadsheet I would like to do the following:
Count the Unique "Provider User IDs" (column C) that meet the following criteria:
a) Column H = "Incomplete" OR "Provider Missed"
b) Column K = 3/24/14 < Value <= 4/30/14
c) Column X = "School 1"
I believe I know how to do this...
Hi! I'm attempting to sum all values in a table that that 1. match a specific value in a header (column) and 2. match multiple values in the rows (there are about 20 values). Each of the values I want the data to match are referencing cells that contain the value.
The below formula I pasted...
I have a set of data which contains the following:
This data repeats, so sometimes the date with the last value in will be 2011, and sometimes the only value will be in the earliest i.e. 2008.
The output I need is:
Can't seem to figure out this formula.
I need to create a sum of the top 10 tenant rents for a property.
I was able to create a Large If formula to pull in the top 10 square footages (size) as follows:
+SUM(LARGE(IF('Rent Roll'!$G$1:$G$1000<=$E$42,IF(('Rent Roll'!$G$1:$G$1000>=$M$24)+('Rent...
I have a table with 4 Columns.
ID Name Start_Time Finish_Time
VSL1 Name1 15:00 18:00
VSL1 Name1 12:00 16:00
VSL2 Name2 05:00 15:00
VSL2 Name2 12:00 15:00
What I want to do is to get the total worked time of every ID.
For example, for VSL1 would...
Hi I have data laid out like below,
I am trying to write a formula to go through 1000's of rows in column B (Category) then display all of the records once and add up the totals
e.g. CCON $123.04
I have been able to do this with...
I need some help with a vlookup/sumif formula, which I want to use to get the total amount of sales per employee. In table 1 are the names of the employees in column A. In table 2 are names of employees, but these can occure more than once or not at all, and the sales they make.
Here is the problem:
I need to be able to drive a SUMIF that is incorporating an array from a combo box as in the attached spreadsheet "Sumif Array Manipulation.xlsx" (sorry, I don't have upload privileges so I copy and paste images)
On the Summary tab you see an example of a combo box located...
Hi, I have a question which I hope will be easy to experts such as yourselves. I want to do a sumproduct or sumifs that uses the first two columns as the criteria (e.g. I want all Product A and Color combinations) and I want the number of columns to sum to be dynamic based the week we are in...
I know there have been a number of sumifs and array questions but I could find one that could do what I am looking for. I have two columns D and E in which I would like to sum the differences if they are positive.
Im trying to find a formula that will allow me to return a sum from one column every time a match is found in multiple other columns...
The book is detailing work done on different projects during the week and reporting the total time for each project for that week