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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lady one - 22 Sep 2005 11:41 GMT

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..

Reply to this Message

Bob Phillips - 22 Sep 2005 12:34 GMT

Do you mean

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

Signature

HTH

Bob Phillips

> 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
[quoted text clipped - 3 lines]
>
> musa..

Reply to this Message