IN the worksheet attached, i'm trying to come up with a formula that sum the data in columns A:D if certain conditions are met
In the highlighted yellow cell (H2), i'm trying to SUM anything that has the following criteria:
- Affinity in column A
- "Like itLike it" OR "Love itLove it" in Column B
- Belongs to Test
So for example, the final value in H2 should be 132+126.
please help!
Bookmarks