I've attached a worksheet showing my table with the relevant column info displayed.
The formula would be located in column Q and needs to be able to look at columns I,J and L and find rows where all three values are the same.
Where it finds rows with all of these values matched it should then total the corresponding values in column O. I have provided the result
that I expect throughout column O.
Example: Q3 is totalling O3,O4 and O5 because the formula would have found that columns I,J and L contain the same information on rows 3,4,5
I'm not sure where I'd actually start with creating this formula. Whether a LOOKUP would suffice or whether I'd need to INDEX & MATCH. Can
anyone point me in the right direction? Thanks.
Bookmarks