Remember Me?

#1
February 18th 05, 12:01 AM
 Susannah Posts: n/a
Sum of random cells with positive data

How do I sum numbers from random cells (in other words they are not
sequential or patterned) only if the cells contain positive numbers?

#2
February 18th 05, 02:36 AM
 Dave Peterson Posts: n/a

Are the cells within a single range?

=SUMIF(A1:I99,"0")

If you have to avoid some ranges, you can do it in stages:

=SUMIF(A1:c99,"0")+SUMIF(f1:I28,"0")

Susannah wrote:

How do I sum numbers from random cells (in other words they are not
sequential or patterned) only if the cells contain positive numbers?

--

Dave Peterson
#3
February 18th 05, 10:28 AM
 JulieD Posts: n/a

Hi Susannah

use the SUMIF function
e.g.
=SUMIF(A1:A5,"0")

Cheers
JulieD

"Susannah" wrote in message
...
How do I sum numbers from random cells (in other words they are not
sequential or patterned) only if the cells contain positive numbers?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Minivann Excel Discussion (Misc queries) 2 January 26th 05 09:07 PM Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM Kevin Excel Worksheet Functions 1 December 31st 04 12:57 PM Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:17 AM Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM

All times are GMT +1. The time now is 09:51 AM.