Govind

Posts: n/a

Hi,

Try

=SUMPRODUCT((A1:A200)*(MOD(ROW(A1:A200),2)<0))

Regards

Govind

lolex wrote:

How can I sum-up cells A1,A3,A5,A7..........A199 by using the SUM
function ?

tks. in advance.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Insert rows based on specific value	bob	Excel Worksheet Functions	6	February 29th 08 07:11 PM
Adding Rows to Master Sheet	Excel Newbie	New Users to Excel	1	December 23rd 04 10:56 PM
How do I shade alternate rows in Excel 2002?	drummergirl73	Excel Discussion (Misc queries)	2	November 29th 04 09:17 PM
Use of Exact(or other) function for alternate rows?	yusee_ygs	Excel Worksheet Functions	2	November 3rd 04 08:44 PM
Identifying exact values in alternate rows	YG	Excel Worksheet Functions	1	November 2nd 04 11:25 PM

All times are GMT +1. The time now is 05:32 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us