I think this is an incorrect use of sumproduct but im trying to total a column (QAMT) pulling the result to relevant column headings (B2,B3, etc Months of the years) based on whether the month are in any of four possible columns (QUART1,QUART2, etc) and there is a match in a property number column as well (QPROP) on a spearate table.
=SUMPRODUCT((QAMT),(OR(QUART1=B2,QUART2=B2,QUART3=B2,QUART4=B2))*(QPROP=A6))
I am assuming that SUMPRODUCT doesnt like my use of OR? How do I get around this?
Thanks in advance
=SUMPRODUCT((QAMT),(OR(QUART1=B2,QUART2=B2,QUART3=B2,QUART4=B2))*(QPROP=A6))
I am assuming that SUMPRODUCT doesnt like my use of OR? How do I get around this?
Thanks in advance