Use SumProduct, I think. (Not clear from a casual glance what your VLookUp
is actually doing.) I think there are examples in the archives of this
list.

If not, please give an example of the VLookUp you can do - i.e. one lookup -
but not from the inside of VBA code. Also, indicate what the second check
you want to do is.