I am trying to write a formula that checks whether certain numbers are
present in a column of many numbers.

If these specific numbers are present, then there total should be
calculated. I have experimented with both the SUMIF and SUMPRODUCT formulae -
but to no avail.

so far i have;
=SUMPRODUCT(((I2:I24=H2)+((I2:I24=H3)+((I2:I24=H4) +(I2:I24=H13)))))

The colum to be checked is I2:I24, and the numbers in this column I am
looking for are H2, H3, H4, H13. (this is simplified - in reality there will
be many more)

Many thanks for your help