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

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?

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" <ALex@discussions.microsoft.com> wrote in message
news:0419F0E2-78DD-459A-AB98-EF05F12348C1@microsoft.com...
> 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?
>
>

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?
>
>