-
Countif function error
Hi, Can someone help me with the formula for the countif function. I am trying to compute the number of times an incident is projected on a specific month. I used count if function but since some cells have no value, it shows invalid data type. How can I ignore those cells and count only the cells that have a month data ?
-
Is It possible to calculate the standard deviation based on a certain criteria?
Is It possible to calculate the standard deviation of a set of numbers based on a criteria e.g from column 2 choose only "Standard"
-
Creating a count using COUNTIF across multiple columns
Hi, i would like to count the number of yes's in a column with a corresponding service line in a separate services column my first column has three drop down options yes/no/NA and i would like to be able to count each one So for example: M&E yes = 37 M&E No = 12 M&E NA = 2
-
Taking Weekly Average Every Friday.
Hi all! I have a spreadsheet, on this sheet I have some values I would like the average of as well as dates assigned to these values. Taking the average is not the only thing I need to do, I need to take the average of these values, grouped by week, from Friday to Thursday. Meaning I have to find a way to group the values…
-
COUNTIFS NOT ISBLANK from another sheet
Hello, I am trying to create a =COUNTIFS function, I know the it works up to the NOT ISBLANK part, I don't think I am off by much, but am not sure what I have wrong, can this please be looked at? Thank you so much! =COUNTIFS({Project}, $Project@row, {Status}, Completed$1, {Metrics & Production Dashboard Build End Date},…
-
Issue with INDEX MATCH
Hello Everyone, I have an index match formula that only works for the first row in my sheet and I have no idea why. The first row brings in the right value, all the other rows come back with #NO MATCH. There is data to be pulled back for the other rows and a VLOOKUP works. What am I missing? Thanks!!
-
How to populate Row Link (from Row Properties) as a reference on a different sheet?
I have a column in a target sheet where I manually insert the Row Link (from Row Properties) to the corresponding row in my source sheet. I'm usually interacting with my data in the target sheet, so using that link helps me quickly find the exact place in the source sheet where I can make edits and keeps both sheets in…
-
Does Column Type of Date restrict using IF formulas?
I have a "helper" column with the Column Type of Date and I want to use an IF formula to return a date. However, I only get "#UNPARSEABLE" errors regardless of what I've tried. I have the "Restrict to dates only" checkbox un-checked because I get the error whether it's checked or not... Here is the formula: =IF([Project IT…
-
Formula Help
Hello, I'm trying to create an inventory of all the items we currently have in our uniform room. The first column will have POLO Shirts USED through the year, the second column I would like to have our current stock inventory inside the room.. the third column will indicate if it was either provided to a staff member or…
-
Issue with calculating days between two dates - returns #INVALID OPERATION
Hi All, I have a column Start Date - that is formatted as a DATE column type Then I have a TENURE column - that is formatted as a TEXT/NUMBER column type In the TENURE column I am using the formula; =TODAY() - [Start Date]@row This formula used to work fine for me - but more recently when I log into the sheet it now…
