Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 6
Default Write a sum formula to determine the total of all the numbers bel

how can i do the the work to havee to do
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default Write a sum formula to determine the total of all the numbers bel

The formula to sum all the numbers is =SUM(A1:IV65536)
--
David Biddulph


"cristian" wrote in message
...
how can i do the the work to havee to do



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Write a sum formula to determine the total of all the numbers bel

One way to get the work done is provide more detail in the body of your
message.

Your subject line reads only............

"Write a sum formula to determine the total of all the numbers bel"

The formula to sum all numbers in column A below 46 is

=SUMIF(A1:A100,"<46",A1:A100)


Gord Dibben MS Excel MVP

On Tue, 18 May 2010 13:25:01 -0700, cristian
wrote:

how can i do the the work to havee to do


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
How to determine the formula to generate following numbers? Eric Excel Discussion (Misc queries) 8 July 4th 07 09:08 PM
Need to write 3D formula averaging total sales between 3 workshee Marian Excel Worksheet Functions 3 September 24th 06 03:36 AM
write a function to determine if cells have names andrewm Excel Worksheet Functions 5 June 9th 05 07:28 PM
how write excel formula numbers in column => &=< between 20-40 ron New Users to Excel 4 April 30th 05 02:37 PM
How do I write a formula to subtract a # from a total ONLY if the. JP Excel Worksheet Functions 2 November 17th 04 12:32 AM


All times are GMT +1. The time now is 05:02 AM.

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"