-
Count when 2 conditions are met
Having an issue getting a count when two conditions are met from two ranges/columns from a different sheet. This is what I have but doesn't work: =COUNTIFS([{Serviceability Check Requests Range 2}]:[{Serviceability Check Requests Range 2}], “May 2025”, [{Serviceability Check Requests Range 3}]:[{Serviceability Check…
-
SUMIFS for a 2-Dimensional Array
Hi there, I've got a sheet [Sheet A] that needs to summarize another sheet [Sheet B], where each row on Sheet A needs to reflect a column on Sheet B. I can do this very easily with a SUMIFS function. e.g. Sheet A Row1 =SUMIFS({Sheet B column 3}, {Sheet B column 1}, "example", {Sheet B column 2}, true). The issue with this…
-
Help with Cross-Sheet SUMIFS Formula for Multi-Select Column Reference
Formula Tried: =SUMIFS({Sheet - TCO Cloud Cost Savings Monthly Savings}, HAS({Sheet - TCO Cloud Cost Savings Business Application}, [Business Application]@row), {Sheet - TCO Cloud Cost Savings Savings Status}, "Complete") Error: Incorrect argument set I'm trying to create a metrics sheet that sums values from another sheet…
-
COUNTIFS Struggle – Need a Hand!
Hi everyone! I'm looking for some help with a COUNTIFS formula. I'm trying to count how many contractors vs. employees we have on a sheet. Counting employees was straightforward since there's only one type. However, there are multiple types of contractors, and I'm not sure how to count all of them together. I've attached…
-
Sum If Formula using Column with Multi select drop down
Hello, I am looking for the formula to sum a column (Work Stream) with specific text. The column is multiple select drop down. The drop down options are Available, Unavailable, Assigned and R&R. I need to sum all the rows that contain the drop down option "Available", even if they may contain other drop down options. I…
-
I am trying to build a Sum If with a cross sheet reference but can't think of the formula.
I am trying to build a Sum If with a cross sheet reference to where IF a plant is __x__, and IF the end date was within this current month (not last 30 days, current month), then it will add the values in the actual value column for that plant on a metric sheet. How would I set this up/ what would that formula look like?
-
INDEX COLLECT MAX
=INDEX(COLLECT({Nature of Issue}, {Nature of Issue Count}, MAX({Nature of Issue Count}, 1), {Site Name Helper}, Site@row), 1) Hello, community. I am trying to solve following. I want my formula (above) to return the nature of issue that has the most common nature of issue count for each site {Site name helper}. It is not…
-
Index Max / Children
Hello community, I need a formula that will return the most common value of its children. In the photo below. There are two expanded lists (Chatham and Patcham). I want my formula to capture the most common nature of issue for each location. In this example, Chatham should return 'Power Isolation Process' and Patcham…
-
Merged: Reference Sheet Summary data from another sheet
This discussion has been merged.
-
Help with writing a formula to show Completed and Past Due along with other status.
Hi there, I am able to get all the status to show correctly, except the 'Complete' and 'Past Due', I know its something simple and I am just not thinking of it, help is appreciated! I am using a 'End Date' and '% Complete' Formula used on the 3rd date down =IF(OR([% Complete]@row = 0, ISBLANK([% Complete]@row)), "Not…