V
Vass
Hi, can anyone help please ?
running a DSUM fomula below
=+DSUM(maindata,"it_cost",H1:I2)/100
H1:I2 holds a conditional name for a sales rep to extract his sales from the
data on a specified date.
The problem I have is the Quantity needs multiplying by the it_cost on each
row
before the DSUM result is obtained.
i.e. total sum of all reps sales on a specified date Qty x cost = x
do I extend the DSUM formula to get the required answer?
thanks
running a DSUM fomula below
=+DSUM(maindata,"it_cost",H1:I2)/100
H1:I2 holds a conditional name for a sales rep to extract his sales from the
data on a specified date.
The problem I have is the Quantity needs multiplying by the it_cost on each
row
before the DSUM result is obtained.
i.e. total sum of all reps sales on a specified date Qty x cost = x
do I extend the DSUM formula to get the required answer?
thanks