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!

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!

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

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

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

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 -

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