View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elgee Elgee is offline
external usenet poster
 
Posts: 24
Default Using CTRL to select cells for a formula

Hi -
I tried to search for help on this one before posting - but wasn't sure how
to search for my answer if that makes sense.

Essentially - I work with a very manual spreadsheet with a lot of various
data for project reporting. (Forecasts, Actuals, EAC, Variance etc.) Due to
the format / layout of the worksheet - I often need to use 'ctrl' to select
the cells I want to include in a formula. IE: =sum(f1, f3, f33, f35) etc.
Is it possible to back into a formula like that? IE: I click CTRL and
select the various cells I want to total and I can see that # in the status
bar at the bottom of the screen. Is there a way to copy those cells into a
formula?

Thanks!