View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JLatham JLatham is offline
external usenet poster
 
Posts: 3,365
Default How do I enter a Formula for entire column?

Hopefully one of us did. Goes like that around here at times: one person
reads the question one way, someone else in another. Someone gets to be
right - and that's good for the OP.

"Bernard Liengme" wrote:

Wonder which one of us correctly read the OP's question!
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
In some cell in column F:

=SUM(C:C)+SUM(D:D)-SUM(E:E)


"Gary" wrote:

I can't figure out how to set a Formula for an entire column. If I want
Column F to represent Column C plus Column D minus Column E, what do I
enter?
(Not just for one row, the whole sheet)

Many thanks!

Gary