HOW TO MAKE A FORMULA BETWEEN D=F*C IN THE WHOLE PAGE
 

I've been trying to get the data in column f time the data in column c to be
equal to the data in column d.. D=F*C but it only work if I do it one row at
a time ..I need a formula that work on the whole sheet ,without having to do
it in every single row..
Thanks for your help

musa..

Do you mean

=SUM(D2:D2000)=SUMPRODUCT(F2:F2000,C2:C2000)

--
HTH

Bob Phillips

"lady one" <lady wrote in message
...
I've been trying to get the data in column f time the data in column c to
be
equal to the data in column d.. D=F*C but it only work if I do it one row
at
a time ..I need a formula that work on the whole sheet ,without having to
do
it in every single row..
Thanks for your help

musa..