-
Countifs Formula using a date range given
I have long countifs formulas on a metrics sheet and is pulling all data from an archive sheet. One of the colums on the archive sheet is date. I need to limit the data count on the metric sheet to only count if is it in between (and including) start and end dates given at any time. =COUNTIFS({Score}, "Pass", {Club}, "AAA…
-
Date Formlulas for Dashboard Counter
Hello, Trying to set up formulas from a sheet to post to a dashboard, somehow came up short. I have a number of projects listed in my sheet with a [Go Live] date. I would like to count the following: * Number of projects that are within 30 days of Go Live (but not past go live) * Number of projects that are within 7 days…
-
duration between 5/30/19 and 6/4/19?
Hi all, 2 in May and 2 in June right? 4 total Why does the 2nd row show 3? Darrell
-
Weeks Out - Production Timeline Templates
I'm trying to replicate a function that is helpful for creating production timeline templates, that I use in google docs. Column A is the due date of a task. Column B is the number of weeks out from your launch date. Column A is calculated by taking your launch date and subtracting the weeks out, to create a due date for…
-
Auto filling a Formula
I am using a formula to do a COUNTIFS based on Dates, a drop down YES/NO column and a name. I am wondering if it possible to auto fill the name portion of the formula from another cell. The formula looks like this: =COUNTIFS($Date:$Date, <=DATE(2017, 6, 30), $Completed:$Completed, ="Yes", $[Assigned to: Editor]:$[Assigned…
-
COUNTIF Checkbox Marked and Then COUNT Product
There is a column called "Terminated" and it is a checkbox and 5 other columns with Product1, Product2, Product3, Product4, and Product5 which are also checkboxes. I need a formula to COUNTIF "Terminated" is Checked, then COUNT the Product1, Product2, Product3, Product4, and Product5 columns. For Example: Terminated =…
-
using IF together with AND
Sorry in advance if this has been answered but I have searched and cannot see the answer but I am sure its simple! I have target finish and actual finish columns, in the status column, I want to report "in progress", "overdue" and "Complete" I have got "in progress", "overdue" to work by the following: =IF(TODAY() <…
-
Vlookup with cross sheet reference
Can someone please provide an example of the Vlookup formula with the cross reference? I have tried both formulas below and get errors on both. =VLOOKUP([New Job Code]1, {Lot Status Report - Goldmark Range 3}, {Lot Status Report - Goldmark Range 3}2, false) #UNPARSEABLE =VLOOKUP([New Job Code]1, {Lot Status Report -…
-
If statement based on date
I am trying to create a formula within my "Academic Year" field so that if the "Date" is more than August 25, 2019, the Academic Year field contents will be "2019-20" -- otherwise, the field contents will be "2018-19". =IF([Date]1 > (2019, 8, 25), "2019-20", "2018-19" I am using the date format (2019, 8, 25) based on what…
-
COUNT by Manager and by Product
I have a column called "Manager" and Product columns called Product1, Product2, Product3, etc and these are all checkboxes How can I do a count by Manager of Product? Example: Joe Smith * Product1 - 3 * Product2 - 10 Jennifer Johnson * Product2 - 12 * Product3 - 5 * Product5 - 10