G
Guest
The SUMIF formula in the active worksheet must total the the values in a
column for rows in another worksheet that satisfy a different condition in
each of two columns (cell ranges) in that same work sheet. The conditions
are also referenced in the active worksheet
Example: For all rows in other worksheet where column A = X and column B =
Y, sum column C.
What I have tried so far without success is
=SUMIF(AND(Other!A5:A400,Other!N5:N400),AND(A14,C15),Other!C5:C400)
column for rows in another worksheet that satisfy a different condition in
each of two columns (cell ranges) in that same work sheet. The conditions
are also referenced in the active worksheet
Example: For all rows in other worksheet where column A = X and column B =
Y, sum column C.
What I have tried so far without success is
=SUMIF(AND(Other!A5:A400,Other!N5:N400),AND(A14,C15),Other!C5:C400)