| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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.. |
|
#2
|
|||
|
|||
|
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.. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i make a sum formula ignore #div/0! errors in the range | Excel Worksheet Functions | |||
| How do I make a cell appear empty when the formula = 0? | Excel Discussion (Misc queries) | |||
| how do i make a cell date sensitive to execute a formula or input. | Excel Discussion (Misc queries) | |||
| Help with formula to make cell blank | Excel Worksheet Functions | |||
| Formula to make Excel count business days/skip weekends? | Excel Worksheet Functions | |||
Hybrid Mode
