#1   Report Post  
Old June 4th 09, 05:01 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 13
Default SUM TOTAL

I need help with totaling a range of cells G12:G46. My problem is that not
all cells contain values for the formula in these cells so it is not allowing
me to do so. This is on a quote sheet and I would like to subtotal as I go,
can anyone help?
--
Chris

  #2   Report Post  
Old June 4th 09, 07:32 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default SUM TOTAL

see your other post

--
Biff
Microsoft Excel MVP


"Chris" wrote in message
...
I need help with totaling a range of cells G12:G46. My problem is that not
all cells contain values for the formula in these cells so it is not
allowing
me to do so. This is on a quote sheet and I would like to subtotal as I
go,
can anyone help?
--
Chris



  #3   Report Post  
Old June 4th 09, 07:33 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2009
Posts: 7
Default SUM TOTAL

What sort of data do you have in the cells? You may be able to use the
subtotal function to add data in groups, by sorting first on the relevant
columns and using data - subtotals in 2003 or the subtotals option on the
ribbon in 2007. Can you give a bit more detail?

"Chris" wrote:

I need help with totaling a range of cells G12:G46. My problem is that not
all cells contain values for the formula in these cells so it is not allowing
me to do so. This is on a quote sheet and I would like to subtotal as I go,
can anyone help?
--
Chris



Reply
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
Duplicate Running Total Grand Total In Pivot Table Mathew P Bennett[_2_] Excel Discussion (Misc queries) 1 August 17th 08 03:13 AM
Excel 2002 : Any single button to get sub total and grand total ? Mr. Low Excel Discussion (Misc queries) 2 May 22nd 07 08:46 AM
Total column changes colors when total equals sum of other columns newstacy New Users to Excel 1 April 21st 07 09:00 PM
Pivots - Auto calc % Sub total is of grand total VBA Noob Excel Discussion (Misc queries) 3 August 8th 06 08:46 PM
Adding Data Using Multiple Worksheets to Total into a Grand Total Lillie Excel Worksheet Functions 1 April 19th 05 08:34 PM


All times are GMT +1. The time now is 12:21 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017