Dear Alex,
You can use the following formula. This formula is so powerful it can sum
based on a number of criteria. You enter this formula as an array by
pressing Ctrl+Shift+Enter Key).

The referneces you can change as arranged in your worksheet

=SUM(IF(H1=J1,IF(A1=E2,D1:E5)))

Hope you can get the desired results. In my office work, I use this formula
to get the results from different workbooks.

Kind regards..john britto

"ALex" wrote:

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?