View Single Post
  #3   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?

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