Re: How to calculate fixed rows in Excel ( Sum of every 7 rows for i..
From: Max (demechanik_at_yahoo.com)
Date: 09/11/04
- Next message: elena_p_mk_at_hotmail.com: "How do I unlock Microsoft Office?"
- Previous message: cutemom2jen: "staff monthly scheduling problem"
- In reply to: Max: "Re: How to calculate fixed rows in Excel ( Sum of every 7 rows for i.."
- Next in thread: tonytaocheung: "Re: How to calculate fixed rows in Excel ( Sum of every 7 rows for"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 11 Sep 2004 21:01:12 +0800
Clarification: Had assumed there were typos in your post ..
> ....say, i select A1 to A6 and sum it but when draging down, it is
> from A2 to A7, but i wanted A7 to A13, then A14 to A20
and that you actually wanted the summations of 7 days expenses
at a stretch when the formula in the start cell is copied down, viz.:
A1:A7
A8:A14
A15:A21
etc
-- Rgds Max xl 97 --- Please respond in thread xdemechanik <at>yahoo<dot>com ----
- Next message: elena_p_mk_at_hotmail.com: "How do I unlock Microsoft Office?"
- Previous message: cutemom2jen: "staff monthly scheduling problem"
- In reply to: Max: "Re: How to calculate fixed rows in Excel ( Sum of every 7 rows for i.."
- Next in thread: tonytaocheung: "Re: How to calculate fixed rows in Excel ( Sum of every 7 rows for"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
