I have 2 array formulas on a sheet that i would like to combine.
Array 1 works independently by itself
=IF(M7="","",SUMPRODUCT(($C$19:$K$27=M7)*IF(ISNUMBER($C$16:$K$16),$C$16:$K$16))+(N7))
Array #2 is like the first just pulling from another range of data, but when it runs I would like it use the answer from the first one if the data in "M7 & M63" are the same.
=IF(M63="","",SUMPRODUCT(($C$75:$K$83=M63)*IF(ISNUMBER($C$72:$K$72),$C$72:$K$72))+(N63))
Maybe something like this
=IF(M63="","",SUMPRODUCT(($C$75:$K$83=M63)*IF(ISNUMBER($C$72:$K$72),$C$72:$K$72))+SUMPRODUCT(($C$19:$K$27=M7)*IF(ISNUMBER($C$16:$K$16),$C$16:$K$16))+(N7))
it seams to work but can it be simplified
Bookmarks