Home |
Search |
Today's Posts |
#1
|
|||
|
|||
=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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|