-
Unique numbers in a column
I have a sheet that we add rows to everyday. One peice of data that is added with every new row is a case number (unique identifier to show us who we are working on). How can I get a total of unique case numbers? I simply want a count of all case numbers no duplicates. So if case 12345 is on my sheet 5 times I only wanted…
-
effort and allocation-based timelines?
We have a small team, with each member having very a specific area of expertise. As such, our timelines are defined by prioritization of tasks, dependencies, effort, and resource allocation. I want to enter my tasks, set their dependencies, effort in hours, priorities, plug in the resources and set their allocation, and…
-
Formula for calculating installs for a given quarter. Q1, Q2, etc..
i have this formula for calculating installs YTD for a given property. =SUMIFS({Mira Santi Install QTY}, {Mira Santi Install Date}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())) Not sure how to take this formula to use it to calculate installs for a given quarter. Do i just put the date range for the quarter? i.e Jan 1,…
-
INDEX(MATCH) returns #INVALID COLUMN VALUE
I have two sheets with a common "Name" column between them. I would like for a checkbox in the second sheet to reflect in the first sheet, factoring in that not all of the names will be used in the second sheet. I would normally use INDEX(MATCH) for this purpose. MATCH() is able to return the row number for the Name where…
-
Calculating Count of Projects by PM by Month
Hi, Trying to create formula to calculate How many projects start in a certain month by each Project Manager - My excel formulas are weak Master sheet has columns: Project Manager is Contact List (does this have to be a Text/Number Column?) Project Start Date - is Date type Column =COUNTIFS({Keller Project Summary - MASTER…
-
Formula for finding the first and last days of a year
I need to be able to calculate the first and last days of the year based upon the current date. Can someone help me out?
-
IF formula issue
The formula I've created isn't working correctly and I can't figure out what I'm doing wrong. =IF([New NCN Score Total]120 = 15, IF([New NCN Score Total]120 <= 14, IF([New NCN Score Total]120 <= 9, IF([New NCN Score Total]120 <= 6, "Very Good"), "Good"), "Poor"), "Very Poor") Scores 15 = Very Good 10 to 14 = Good 7 to 9 =…
-
Help with SUMIFS & INDEX/MATCH Formulas
I need to first find the column number where the number 1 resides on the "Lookup Value -->" row. Next, I need to shift two columns to the right, which would be "4/2019 C" and sum the values for Client B, I have tried various combinations of SUMIFS, INDEX(MATCH()), etc.,but with my last attempt, I received #INVALID VALUE…
-
Count if date is last 7, 30, X days
I have a sheet that lists feature requests. The system automatically generates a date when the request was submitted. I have summary columns up top of how many features were requested Q1-Q4 but I would like to add in counts for the past 7 days and 30 days. I would like a formula so the counts automatically update without…
-
Sum ifs 3 criteria
I'm looking for the sumifs= Status column is "green", The Trans Date column in January 2018 the reversed column is unchecked. So far I only have the first part of the formula working. I cannot figure out how to include the rest =SUMIF(@{Collections Range 3}, @cell = "Green", {Collections Range 1}) This information will be…