LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Leaving a total sum cell blank until other cells are filled

Hi there, some help needed please for probably a simple problem.

Lets say I have a value in cell A1. A2 is blank for now and the total
of the SUM will be in A3.

How can i get it so that A3 is blank until A2 is filled in.

Any would be appreciated
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding cells but leaving blank if not populated Scoober Excel Worksheet Functions 2 November 5th 09 08:08 AM
Leaving Cell Blank Ron A.[_2_] Excel Worksheet Functions 2 October 6th 09 05:36 PM
Leaving Cell Blank. GEM Excel Worksheet Functions 3 January 20th 09 12:09 PM
Colouring Ranges & Leaving Cells Blank klam Excel Discussion (Misc queries) 1 May 2nd 07 03:45 PM
Leaving a cell blank. Not NA(), not "". Incoherent Excel Worksheet Functions 4 September 30th 05 05:36 PM


All times are GMT +1. The time now is 09:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"