An additive effect is the straightforward sum of two substances doing the same thing. Two mildly sedating products taken together can produce impairment that neither would cause alone, without either being unusual on its own.
This is the most common and most underestimated interaction in everyday life, because many over-the-counter cold, allergy, and sleep products are sedating.