-
Index/Match is almost completely broken
Hi guys, I don't really know what's happening, and it's honestly the first time that it's happening to me. I have used this specific INDEX/MATCH syntax without issue, up until today. =IFERROR(INDEX({Office Time Zone}, MATCH([Office Number]@row, {Office Number Ref Sheet}, 0)), "") It's doing what I told it to, which isโฆ
-
How do I use the SUMIFS function with the OR function?
I am trying to sum the total of amounts listed in column 1 if a specific name is in column2, or column3, or column4, or column5, or column6 AND the column7 ="won". Names can be listed in multiple columns in a single row. I want to avoid double counting an amount. I cannot seem to find a similar formula but I read it isโฆ
-
SUMIFS I think?
I am trying to count a total number of employees in a multi-select drop down and also only count those employees if they attended meetings in November, December, January, Etc. All of this data is absorbed via a form. My current formula is: =SUMIFS([Employees at meeting]:[Employees at meeting], >1, Date:Date, AND(@cell >=โฆ
-
How to Apply Filters in One Row that Adjusts Price in Another
I have a sheet that tells me the price of a product based on whether it's "Completion" is checked or not. I need to be able to filter the "Position" column to show me "Only Angle A" or "Only Angle B" etc. AND, I need the "Price" column to adjust appropriately when these filters are applied. The idea is that if we only wantโฆ
-
Collect the most recent Data from 2 sheets
Hi All, Here is the scenario, I have a master list of clients with the pertinent data for our business partners to reference. How ever we have an update sheet that has been built to request changes to that master list if needed. I would like to have data update in my row of the master list once there is an update from theโฆ
-
Summary Data for a report
I have two sheets that have a lot of data on them, and I am using a Summary report to find out the % of task done on one of those sheets. How can I then pull the data from both of them into one report to see all the data I need to see? Example: One sheet has client name, contact information etc... The other sheet hasโฆ
-
Formula to return different values
Hello, I am trying to write a formula to return one value if a certain criteria is met, and a different value if that criteria is not met. What I have is below. It's not working, but I'm not sure how to fix it. Any ideas? =IF(Dates@row <= $Dates$2, SUM([Actual Cumulative Labor]10 + [Planned Billable Labor]10), ""),โฆ
-
How to change first week number from Jan 1 to July 3 ?
How to change first week number from Jan 1 to July 3 ?ย
-
VlookUp
Hi all, I have an issue that I am hoping one of you can come up with a solution. I have a confidential HR register, I would like to link Sheet A to it just extracting names and department, that will update as staff leave and join. are there any ideas ( My Manager for obvious reasons doesn't want anyone but himselfโฆ
-
formula
How do I do A formula that will If Date Poles Completed is a date then Completion Column will Read "Completed" and if Date of Poles Completed is blank then A will also be blank