Hello all, I would like help to make these formula's dynamic so they do not return an error when there are empty cells but include new data when added.

=SUMPRODUCT((Plant=$H15)*(Month=$I$13)*(Year=$J$13))

=SUMPRODUCT((Plant=$H15)*(Month=$I$13)*(Year=$J$13)*(Alarms))

Thanks

Lewster