Hi to all,
I am trying to use the OFFSET function as a criteria in a DSUM function and I am getting #Value error and quite frankly I really do not know why, I use DSUM as recommended and get no error, tried OFFSET separatly and it is working just fine too,
This is the syntax I am using:
=DSUM(Data!$A$1:$F$757,"Gross Split Commission",OFFSET($B$4,2,0))
my goal is to be able to set the function for each salesman on my list (1 column only)
the label is in B4 and the list of the salesman is underneath, 1 name per line
Can someone shed some light and help me out on this
Many Thanks
I am trying to use the OFFSET function as a criteria in a DSUM function and I am getting #Value error and quite frankly I really do not know why, I use DSUM as recommended and get no error, tried OFFSET separatly and it is working just fine too,
This is the syntax I am using:
=DSUM(Data!$A$1:$F$757,"Gross Split Commission",OFFSET($B$4,2,0))
my goal is to be able to set the function for each salesman on my list (1 column only)
the label is in B4 and the list of the salesman is underneath, 1 name per line
Can someone shed some light and help me out on this
Many Thanks