Maybe this:

=SUMPRODUCT(--(Other!$J$2:$J$10000<""),Other!$J$2:$J$10000=C$4 ),--(Other!$O$2:$O$10000
=
""),Other!$H$2:$H$10000) +
SUMPRODUCT(--(Other!$J$2:$J$10000=""),Other!$G$2:$G$10000=C$4) ,--(Other!$O$2:$O$10000
=
""),Other!$H$2:$H$10000)

HTH,
Paul

--

"JPS" wrote in message
...

=SUMPRODUCT(--(Other!$G$2:$G$10000=C$4),--(Other!$O$2:$O$10000 =
""),Other!$H$2:$H$10000)


The formula above works fine. However, I need to modify it to do the
following:

If Column J on the "Other" worksheet has a value, I need my match to refer
to column J. However, if column J is blank, I need the match to refer to
column G as it is doing above.