Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sums
Is there any way of only working out a sum in the boxes that are used and
discluding the boxes that haven't been used. For example i have a worksheet which includes a column for discounts but it is not always used. Is there any way it can recognise which cells have been used and only work out the sum using those cells? Sorry if i dont make sense! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sums
one way:
=SUM(IF(ISEMPTY(A1:A100),0,A1:A100)) this is an array-formula so CTRL+SHIFT+ENTER it instead of simply using ENTER On 11 Gru, 13:24, Jemma wrote: Is there any way of only working out a sum in the boxes that are used and discluding the boxes that haven't been used. For example i have a worksheet which includes a column for discounts but it is not always used. Is there any way it can recognise which cells have been used and only work out the sum using those cells? Sorry if i dont make sense! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sums
On Thu, 11 Dec 2008 04:24:05 -0800, Jemma
wrote: Is there any way of only working out a sum in the boxes that are used and discluding the boxes that haven't been used. For example i have a worksheet which includes a column for discounts but it is not always used. Is there any way it can recognise which cells have been used and only work out the sum using those cells? Sorry if i dont make sense! If the cells "aren't being used", would they not be empty? In that case, the SUM function will ignore them (as would the addition operator). --ron |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sums
On Thu, 11 Dec 2008 04:43:16 -0800 (PST), Jarek Kujawa
wrote: one way: =SUM(IF(ISEMPTY(A1:A100),0,A1:A100)) this is an array-formula so CTRL+SHIFT+ENTER it instead of simply using ENTER How would the result of this differ from the normally entered: =sum(a1:a100) ??? --ron |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sums
I understood tha the OP only looks for the minimum non-empty cells
if there are empty cells the minimum would '0', or it wouldn't? On 11 Gru, 14:23, Ron Rosenfeld wrote: On Thu, 11 Dec 2008 04:43:16 -0800 (PST), Jarek Kujawa wrote: one way: =SUM(IF(ISEMPTY(A1:A100),0,A1:A100)) this is an array-formula so CTRL+SHIFT+ENTER it instead of simply using ENTER How would the result of this differ from the normally entered: * * * * =sum(a1:a100) ??? --ron |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sums
ooops, sorry
I meant to put this answer in a different thread On 11 Gru, 18:21, Jarek Kujawa wrote: I understood tha the OP only looks for the minimum non-empty cells if there are empty cells the minimum would '0', or it wouldn't? On 11 Gru, 14:23, Ron Rosenfeld wrote: On Thu, 11 Dec 2008 04:43:16 -0800 (PST), Jarek Kujawa wrote: one way: =SUM(IF(ISEMPTY(A1:A100),0,A1:A100)) this is an array-formula so CTRL+SHIFT+ENTER it instead of simply using ENTER How would the result of this differ from the normally entered: * * * * =sum(a1:a100) ??? --ron- Ukryj cytowany tekst - - Pokaż cytowany tekst - |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sums
On Thu, 11 Dec 2008 09:21:17 -0800 (PST), Jarek Kujawa
wrote: I understood tha the OP only looks for the minimum non-empty cells if there are empty cells the minimum would '0', or it wouldn't? I interpreted his request as looking for the SUM of the unused cells: "Is there any "way it can recognize which cells have been used and only work out the sum "using those cells? --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Max sums | Excel Discussion (Misc queries) | |||
SUMS | Excel Discussion (Misc queries) | |||
How to add previous sums in a column to current sums in a column? | Excel Worksheet Functions | |||
Sums | Excel Discussion (Misc queries) | |||
Sums | Excel Discussion (Misc queries) |