starting at row 4
=SUMPRODUCT(--(MOD(ROW(J1:J1000),5)=4),J1:J1000)
Don Guillett
SalesAid Software
dguillett1 austin.rr.com
----- Original Message -----
From: "James Button" <jamesbuttonBLUEYONDER.CO.UK>
To: <EXCEL-GPEACH.EASE.LSOFT.COM>
Sent: Monday, March 12, 2007 8:20 AM
Subject: Re: 2 little easy points......
> For the first one
> If it is every 5th entry then
> =SUMPRODUCT((A1:A50)*(MOD(A1:A50,5)=4))
>
>
> ----- Original Message -----
> From: "Peter Vousden" <petervMARKELLIOT.CO.UK>
> To: <EXCEL-GPEACH.EASE.LSOFT.COM>
> Sent: Monday, March 12, 2007 1:49 PM
> Subject: 2 little easy points......
>
>
>> Hi,
>>
>>
>>
>> Been receiving these emails for a while so it is
about time that I test
> the
>> collective knowledge of all you Excel gurus! So
here goes:
>>
>>
>>
>> 1) Sum non-contiguous cells: Is there a neater way
to perform the
>> following??
>>
>>
>>
>>
>
"=F4+F9+F14+F19+F24+F29+F34+F39+F44+F49+F54+F59+F64+F69
+F74+F79+F84+F89+F94+
>>
>
F99+F104+F109+F114+F119+F124+F129+F134+F139+F144+F149+F154+F
159+F164+F169+F1
>>
>
74+F179+F184+F189+F194+F199+F204+F209+F214+F219+F224+F229+F2
34+F239+F244+F24
>>
>
9+F254+F259+F264+F269+F274+F279+F284+F289+F294+F299+F304+F30
9+F314+F319+F324
>>
+F329+F334+F339+F344+F349+F354+F359+F364+F369"
>>
>>
>>
>> 2) Entering a cell reference instead of a hard
coded figure.. Normally
> good
>> at doing this but doesn't appear to be working with
array formulas.! Any
>> ideas?
>>
>>
>>
>>
>
"=SUM(IF(Order_Book!$H$16:$H$13517>=DATEVALUE("
04/03/2007"),IF(Order_Book!$G
>>
$16:$G$13517<>"Franchise",Order_Book!$S$16:$
S$13517,0),0))"
>>
>>
>>
>> where Cell A1 contains - "04/03/2007"
>>
>>
>>
>> Many thanks in advance.
>>
>>
>>
>> Kind regards,
>>
>> Peter
>>
>>
>>
------------------------------------------------------------
--------------
>> The EXCEL-G list is hosted on a Windows NT(TM)
machine running L-Soft
>> international's LISTSERV(R) software. For
subscription/signoff info
>> and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
>> COPYRIGHT INFO:
>> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
>>
>>
>
>
------------------------------------------------------------
--------------
> The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
> international's LISTSERV(R) software. For
subscription/signoff info
> and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
> COPYRIGHT INFO:
> http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.5.446 / Virus Database: 268.18.8/718 -
Release Date: 3/11/2007
> 9:27 AM
>
>
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
|
