Hi all, please see my example attached.
In cell J2 I have a formula, which is not working correctly.
What I am trying to do, is get the sum where the item (H2) is found in column A, but where the Item2 is not matching what is in cell I2.
So in this instance it should be 0, as the only occurrence of item in H2 is where the Item 2 is also whats in I2.
In row 3, you can see the example working where there are multiple occurrences of item in H3
Thanks in advance
Bookmarks