A
Amanda Guenthner
I am trying to get the sum for something where I need some way to distinguish
it as AND/OR. I tried the following:
=SUMPRODUCT(--(J10:J59="value"),--((K10:K59="value")*(Q10:Q59)))
This works fine if both conditions for column J and K are met, but I want to
be able to get the sum if J and/or K is met. I tried inserting and 0R and +
between the two arrays but it did not work.
Help is much appreciated!
it as AND/OR. I tried the following:
=SUMPRODUCT(--(J10:J59="value"),--((K10:K59="value")*(Q10:Q59)))
This works fine if both conditions for column J and K are met, but I want to
be able to get the sum if J and/or K is met. I tried inserting and 0R and +
between the two arrays but it did not work.
Help is much appreciated!