J
Joseph N.
[Excel 2003] Assume a worksheet with with numbers in column A; Boolean
criterion [Y or N] in column B; and another Boolean criterion [Y or N]
in column C. I would like to add the numbers in column A for all rows
that have 'y' in both columns B and C.
I have been trying to do this with a SUMIF statement in which the
criteria is a combination of the two columns. I have not been able to
find the magic formula, so either I am missing the correct syntax or
there is a better formula to use.
Help would be appreciated!
criterion [Y or N] in column B; and another Boolean criterion [Y or N]
in column C. I would like to add the numbers in column A for all rows
that have 'y' in both columns B and C.
I have been trying to do this with a SUMIF statement in which the
criteria is a combination of the two columns. I have not been able to
find the magic formula, so either I am missing the correct syntax or
there is a better formula to use.
Help would be appreciated!