-
Need help with Countif function please!
I would like to count the rows where: The "Sales Person" (contact) column is "Kevin Mielke", and also the "Stage" column is one of the following values: "1-Design", "2-Estimating", "3-Delivered", or "4-Contracting". This is what I came up with but it says "incorrect argument set": =COUNTIF([Sales Person]:[Sales Person],…
-
5x5 Risk management formula
Can anyone figure out what's missing in this formula to set a rating from a 5x5 risk matrix. I copied the format from the risk assessment matrix template set that is a 4x3 matrix and modified. =IF(AND(OR(Likelihood5 = "Rare", Likelihood5 = "Unlikely", Likelihood5 = "Possible", Likelihood5 = "Likely"), Consequence5 =…
-
Sum children if a condition is met in another column
Hi, Im trying to count the children of column [Estimado Importe Total] but I just want to count the values if the condition in column [Estatus Factura] says "Pagada", if not I just want to skip that row and count the rest of the conditions that are met. Here is my example: Hope someone can help me. Thankyou!
-
Return Data based on two conditions being met
Hi, Please can you assist with a formula that checks data from two cells within a sheet that will then populate a matrix sheet. The data sheet is being populated via form currently. If Property Name is "Mykonos" and if Quarter 2, then return the % Score I keep getting "Incorrect Argument Set Errors" :( In the Matrix, I…
-
Log the date and time a cell changes to a specific value
Hello. I've got a sheet I've developed to track approval of purchase agreements. After an agreement makes its way through the approval process, I have the cell "Final Approval" display the words Agreement Final Approval, and the cell is conditionally formatted to red. The main users would like me to log the time and date…
-
Tracking date when a drop down value is selected
I'm creating a project tracker where I can assign what phase the project is at (design, prototype and complete). What I want to do is track how long the project is in each phase, so what I plan on doing is tracking when the drop down items are changed. I thought of using an IF statement where if "design" is selected, then…
-
Index and Match Vs Vlook up
Hi all, I was advised to use Index and Match as I am pulling dates from various schedules into one sheet. Last time Vlookup worked really well however there was a limit of 25000 links. Now I am using index and match and the limit is even low. It says I have reached a limit for cross reference. Kindly advise.
-
Automatically autopopulate a cell from a cell in the same column based off the date in its row?
I want data I enter to automatically input into my summary table if it is from the previous month. Can you automatically autopopulate a cell from a specific column into another cell based off of the date from its row? For example, can I have the Associate Healthcare number from last month automatically populate into the…
-
Column formula edit
I was able to convert a row formula to a column formula. However, now I need to edit it and am getting the message that only the sheet owner and admins can edit. I am the sheet owner. What do I need to do to edit the column formula? Thanks in advance!
-
Copy rows to another sheet with formules
Hello, Is there any way when I copy rows with formules from one sheet to another to keep the formules? Did not work for me so I doing the formules again. Best Rehards, Angela Formiga