You can use SUMPRODUCT, but this must be on a specified range, not a column

=SUMPRODUCT(--(Input!H1:H1000=AZ19),--(Input!A1:A1000=E2),Input!E1:E1000)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ALex" wrote in message
...
I would like it to SUM IF (Input! Column H = to cell AZ19 AND Input!
Column A
= to cell E2 , then sum Input! Column E)

The two conditions:
Input! Column H = to cell AZ19
Column A = to cell E2

must be true

for the SUM of Input! Column E to occur.

How would this formula work?