Hi,

I am getting a #value error when trying to use Dsum with Offset as a criteria.
I am very rusty with Excel so some help will be very appreciate. This is the formula I am trying to use:=DSUM(Data!A2:F750,"Gross Split Commission",OFFSET(B10,2,0))
but it get me an error on the Offset part, the column which contains the data is set as text for the datatype, the error is saying "A value used in the formula is of the wrong data type"
The first row which contains the results is the regular DSUM expression
because each row has a different ID, this is where the offset part, I think, come to play or there is something else I am missing.=DSUM(Data!A1:F749,"Gross Split Commission",$B10:$B11)

col B col C col D
ContactID
=100764 Gilles Barry $966,977 =DSUM(Data!A1:F749,"Gross Split Commission",$B10:$B11)
=463 Talie Demirdjian #VALUE! =DSUM(Data!A2:F750,"Gross Split Commission",OFFSET(B10,2,0))
=102315 Marie-France Desrochers
=35 Johnny Dethier
=95710 Aida Istodor

Thanks

I am trying to summ the sales based on 1 person using their ID (integer from SQL), the data is coming from another sheet on the same workbook