D
David Stricklen
I have the following formula,
=IF(G5=2000,(SUMPRODUCT((Detail!$A$6:$A$10000=C5)*(Detail!$E$6:$E$10000=G5)*-1,Detail!$O$6:$O$10000)),IF(OR(E5=6,E5=21),(SUMPRODUCT((Detail!$A$6:$A$10000=C5)*(Detail!$G$6:$G$10000=G5),Detail!$O$6:$O$10000)),SUMPRODUCT((Detail!$A$6:$A$10000=C5)*(Detail!$G$6:$G$10000=G5),Detail!$O$6:$O$10000)*-1))
which works perfectly fine, but instead of just summing the O column, I would like it to sum O and P. However when I change it to Detail!$O$6:$P$10000, it gives me a #Value error. Any suggestions?
David
=IF(G5=2000,(SUMPRODUCT((Detail!$A$6:$A$10000=C5)*(Detail!$E$6:$E$10000=G5)*-1,Detail!$O$6:$O$10000)),IF(OR(E5=6,E5=21),(SUMPRODUCT((Detail!$A$6:$A$10000=C5)*(Detail!$G$6:$G$10000=G5),Detail!$O$6:$O$10000)),SUMPRODUCT((Detail!$A$6:$A$10000=C5)*(Detail!$G$6:$G$10000=G5),Detail!$O$6:$O$10000)*-1))
which works perfectly fine, but instead of just summing the O column, I would like it to sum O and P. However when I change it to Detail!$O$6:$P$10000, it gives me a #Value error. Any suggestions?
David