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