Microsoft Certification - Re: Adding cells in Excel

07-30-2003, 07:34 PM

Yes.. you can do something like this:

(View w/ a constant width font, such as Courier New)

A B

1 CellsToSum SumBit

2 1 1

3 100 0

4 2 1

5 200 0

6 3 1

7 300 0

8 =SUMIF(B2:B7,1,A2:A7)------>6

9 =SUMIF(B2:B7,0, A2:A7)----->600

10 =COUNTIF(B2:B7,1, A2:A7)--->3

11 =COUNTIF(B2:B7,0, A2:A7)--->3

12 =A8/A10-------------------->2

13 =A9/A11-------------------->200

"Jean" <> wrote in message
news:033601c355fd$b8bda8f0$...
> Is there a formula to SUM or AVERAGE every OTHER cell in
> a range? In other words, is there a function that can be
> used to avoid typing something similar to =sum
> (a1,a3,a5,a7,a9)?

Martin Schmid

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VB with excel	sanju	Software	0	04-02-2008 06:14 AM
Save an Excel file, created from a DataGrid, programmatically..	tapasmahata	Software	0	01-12-2008 05:39 AM
How to run a Excel Macro from the Java application?	Kiranu	General Help Related Topics	0	09-12-2007 02:11 PM
Uploading Excel file into sql table	shalim	Software	1	10-31-2006 08:57 AM
DVD Verdict reviews: EXCEL SAGA: IMPERFECT COLLECTION and more!	DVD Verdict	DVD Video	0	09-02-2004 10:08 AM

07-30-2003, 07:34 PM	#1
	Re: Adding cells in Excel Yes.. you can do something like this: (View w/ a constant width font, such as Courier New) A B 1 CellsToSum SumBit 2 1 1 3 100 0 4 2 1 5 200 0 6 3 1 7 300 0 8 =SUMIF(B2:B7,1,A2:A7)------>6 9 =SUMIF(B2:B7,0, A2:A7)----->600 10 =COUNTIF(B2:B7,1, A2:A7)--->3 11 =COUNTIF(B2:B7,0, A2:A7)--->3 12 =A8/A10-------------------->2 13 =A9/A11-------------------->200 "Jean" <> wrote in message news:033601c355fd$b8bda8f0$... > Is there a formula to SUM or AVERAGE every OTHER cell in > a range? In other words, is there a function that can be > used to avoid typing something similar to =sum > (a1,a3,a5,a7,a9)? Martin Schmid