ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Write a sum formula to determine the total of all the numbers bel (https://www.excelbanter.com/excel-worksheet-functions/264071-write-sum-formula-determine-total-all-numbers-bel.html)

cristian

Write a sum formula to determine the total of all the numbers bel
 
how can i do the the work to havee to do

David Biddulph[_2_]

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




Gord Dibben

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




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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com