LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
PaulStroik
 
Posts: n/a
Default Adding columns (one with a formula)


When I try to enter a formula in a fourth column get a sum of three
other columns only two of the three other columns work. The one column
which does not has an extensive formula to it. Would this be the reason
why? I receive no errors when entering the column 4 formula. Here is the
formula I enter in E7.

=SUM(E4,E5,E6)

Only E5 and E6 work. E4 has another formula in it. Would this cause it
not to work in the total of E7?

Thanks in advance for any help in this.


--
PaulStroik
------------------------------------------------------------------------
PaulStroik's Profile: http://www.excelforum.com/member.php...o&userid=24640
View this thread: http://www.excelforum.com/showthread...hreadid=382343

 
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
Columns FemIce Excel Discussion (Misc queries) 1 September 28th 05 09:29 AM
Formula that looks at two columns Ralph Smith Excel Worksheet Functions 3 May 24th 05 09:22 PM
Adding an extra validation to this formula. Mindie Excel Discussion (Misc queries) 1 March 7th 05 11:49 PM
ADDING NUMBERS IN COLUMNS ACROSS IN EXCEL lost in translation Excel Worksheet Functions 2 February 4th 05 10:40 PM
Perform functions on the result of adding two columns Tim Archer Excel Worksheet Functions 2 February 2nd 05 03:25 PM


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

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

About Us

"It's about Microsoft Excel"