-
COUNTIFS and SUMIFS with a Date Range
Hello, I'm trying to count the number of cells that have a date in the year 2020. This is the formula that is returning "0" which is incorrect: =COUNTIFS([Column 1]:[Column 1], <=DATE(2020, 12, 31), [Column 1]:[Column 1], >=DATE(2020, 1, 1)) Additionally, I want to sum the values that correspond to this date range, and…
-
COUNTIFS to count return with 3 conditions
=COUNTIFS({SP Migration Sentiment Range 8),wave1,{SP Migration Sentiment Range 3}, <8, {SP Migration Sentiment Range 3}, Need help on this formula. Ultimately, need to count value between 4~7 along the value of Wave 1
-
#INVALID VALUE on index and match function
I am using an index and match function to show how much weight someone has lost each week. I was able to get the values for Week 1, but I cannot produce beyond that. I am copying over the formula and it is still pulling based off of name and week number but getting #INVALID VALUE.
-
IF and AND nested possible?
Hello there! I'm looking to have multiple nested IF statements which would allow me to have a cell say different things depending on what range the value falls within. For example, I have the following data: So far, I have made the following: =IF(AND(E3>=15.5,E3<25.1),"Dorval Airport","") But any further IF or AND…
-
Children from a different column
I'm working on a stock inventory program for my company. The Parent row is the Running total, min/max barcode, description and so on. The Children will be the stock coming in and going out. I can on the Parent row Sum Children in IN column an then Sum Children in OUT column them have the formula in Parent Stock cell…
-
Status corresponding to % Complete
I would like to figure a way for the Status Column to auto fill depending on what the % Complete says. For instance: 0% = Not Started 1-99% In Progress 100% - Complete Conditional Formatting is not the way to go and I can't figure out the right If/Then statement to use. New to this world so don't think down on me too much.
-
Is there a way to return the row location of all instances of a duplicate value within a column?
I've created a duplicate flag column using the following formula: =COUNTIF(Email1, Email1) + " of " + COUNTIF(Email:Email, Email1). This shows the instance and the count. What I would like to be able to do is provide the row numbers of the duplicate emails. Match will only find the firs duplicate but won't return all of…
-
Consecutive Count of Children
Please help. This seems like it should be a fairly simple answer, but I’ve worked on this for hours with no success. I would like a count formula that counts the Children, and numbers them consecutively. I can then use an embedded IF statement to calculate specific hours attributed to each Child. This simple formula,…
-
How do you sum one colunm if it matches the criteria from two other columns
Need help with this formula I want to sum one colunm if it matches the criteria from two other columns =SUMIFS({PO Form - Range 3}, {PO Form - Range 1, ="Proj:01",[{PO Form - Range 2} = "Stationary"}])
-
Calculating Total Working Hours between Sign In & Sign Out
Hello, I'm facing difficulty of summing up Total Working Hours in the worksheet. I'm working on calculating a simple total working hours for my employee, they just fill in Smartsheet form then the worksheet will calculate it. I need help on which solution work best on this project. Below I provide the details: Employee…
