=SUMPRODUCT(--(MOD(ROW(A43:A65536),40)=3),A43:A65536)
If it doesn't work as I show, try entering it as an array formula with
CTRL+SHIFT+ENTER.
On Thu, 31 Mar 2005 18:03:01 -0800, "Mutcluck"
wrote:
How can I Sum
A43+A83+A123+A163 into infinity.
This is crucial to making a worksheet to track #'s of resumes from various
web postings over time.
|