M
mckzach
Greetings, all
I'm attempting to sum a column of VALUES if/when the criteria in two other
columns of TEXT is met. However, the SUMPRODUCT function I'm using is not
returning anything (no errors, but no sum either).
=SUMPRODUCT(--($C$2:$C$4000="New York"),--($A$2:$A$4000="HOUSE"),$X$2:$X$4000)
Any ideas why this particular formula isn't working, or suggestions for
other means of capturing what I need?
Thanks in advance
I'm attempting to sum a column of VALUES if/when the criteria in two other
columns of TEXT is met. However, the SUMPRODUCT function I'm using is not
returning anything (no errors, but no sum either).
=SUMPRODUCT(--($C$2:$C$4000="New York"),--($A$2:$A$4000="HOUSE"),$X$2:$X$4000)
Any ideas why this particular formula isn't working, or suggestions for
other means of capturing what I need?
Thanks in advance