Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula - sum "x" column L only when same row contains "y" columns
One column has unit locations at a facility and an array of three columns has
"qualifications" meeting other criteria of events at same facility. Each row represents an "unique identity". Need to create a formula that only counts a particular "unit location" if it shares the same row ("unique identity") that meets a particular "qualification" appearing among other "qualifications" within the three column array. Example: Count (get a sum of) only the "unique identities" that are in room "A" (unit location) and which wear the color black (qualifications). In other words, if "A" matches cells in same row that contain "black", what is the sum of "A's". |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I reference every "n" cell in a column in Excel? | Excel Worksheet Functions | |||
XL formula - total of row = total of column | Excel Worksheet Functions | |||
Move column values w/o formula | Excel Worksheet Functions | |||
how to enter a formula using column() function for a range | Excel Worksheet Functions | |||
Adding TR to the end of each value in a column..formula | Excel Worksheet Functions |