View Single Post
  #2   Report Post  
Max
 
Posts: n/a
Default

Perhaps ..

Put in J1: =SUM(H1:I1)
Copy down

Put in G1: =E1*F1
Copy down

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Angel Zephyr" <Angel wrote in message
...
I want to set up the whole page to do some math for me, without having to

do
each individual row/column. I want all of j to equal h plus i, and all of

g
to equal e times f. Is there a way to set that up for entire columns?

Thanks!