Hello,
I have some problam in following formula, I_col has Amount
=SUMPRODUCT((F21:F3000="U")*(G21:G3000="Jamaica Office")*I21:I3000)
this error is coming out. #VALUE!
Thanks/Tufail