-
Sumifs, referencing another sheet with two conditions
I am trying to add numbers based on 2 conditions. I am referencing another sheet. I am using the following formula: =SUMIFS({FY21 AA AMER Budget US$}, {FY21 AA AMER Quarter}, contains "2021",[{FY21 AA AMER Marketing Cost Type}, contains "Content"]) I want to add the budget for AA AMER if the following two conditions are…
-
Trailing 12 weeks/months style report
I'm looking to create sheet that will roll up data for a trailing time period. I can collect the data easily enough, but of course, the data changes over time. Is there a way to collect the data, then freeze it and collect new data in a new cell? I don't have a problem pre-building the sheet with all of the future dates,…
-
Need to average a range within a certain month
I am trying to average a column that has its own set criteria and calculating it with in a month. I am separately doing these two formulas but now want to combine it. My first formula:. =IFERROR(AVG(COLLECT({time in days}, {hospital specialty}, "Acute Care", {job type}, <>"PCT")), "") This gives me an average time to…
-
How do I count cells that include a value and not just cells that only have a specific value in it?
I'm trying to count the amount of cells that have a value of "keys" included in it, but it's only giving me the cells that specifically only contain "keys". I want every cell that contains "keys" within any portion of it. Below is the function I've used. =COUNTIFS([Key/ Swipe/ Code Request]:[Key/ Swipe/ Code Request],…
-
SUM of Only Parents in Budget Sheet
Hello! I've created a budget sheet with sub items. I figured out how to SUM the Children under a Parent line but what is the simplest way to SUM only the Parents for a Total that does not include both Children and Parents? Thank yo!
-
Calculating/adding anniversaries with date functions
Good morning, hoping someone can help out with this. I'm trying to create a formula using hire date and today's date to calculate the number of years working for a company. For example, if someone was hired October 12, 2019, I would like to have a "years with company" automate to "2" and send a notification to my e-mail.…
-
CountIFS with "OR" "AND"
Hello experts! I'm using these formulas for my dashboard, I have the formula working that will give me the total tasks for "Web/IT" and "IT" as the following: =COUNTIFS(RESOURCE6:RESOURCE152, OR(@cell = "Web/IT", @cell = "IT")) … the total was 6 Now I want to then calculate out of those total tasks, which are check as…
-
How to link 2 cells in different worksheets?
Hi, Trying to figure out on what formula or function can I use to link 2 cells in different worksheets. Goal is to have the other cell auto update once a value is entered in a cell in a different sheet. The date type is number. Looking for any suggestions.
-
Date from Week Number
I'm currently using a sheet with a =WEEKNUMBER([Date]@row) formula to group using the Pivot Table App. In the pivot table, I would like to display a date for the group in addition to the week number, as a "Week Start" column. Example: The Pivot Table displays 42 for the week number. I'd like it to show with an additional…
-
Nested Criteria error only for one row
Hello Community, I have a column formula that works fine for every row except one. This particular row is not any different that I can see from the others. I apologize for the length of the formula, I will do my best to isolate and breakdown the issue I am having: Here is a pic of a test column created to work out the…
