=SUMIF(Input!H2:H718,AZ19,Input!E2:E685)AND(IF

[Guest]

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?

 

[Bob Phillips]

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)

 

[Guest]

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