I am trying to sum the values in a column based on data in two other columns
of the same row meeting specific criteria.

I have data in A2:A10, C2:C10 and E2:E10 and I only want to sum the values
in A2:A10 if spedified, different criteria is met in BOTH C2:C10 and E2:E10.