LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default How to use sum/average function on 3 consecutive values

Hi,

This may sound like the easiest question, but believe me its not. I'm
strugling with it for quite some time now.

Let me explain what is that I want. I have data for several customers
on their daily order values. Customers in rows and days in columns.
Say

day1 day2 day3 day4
day5 day6
cst 1 11 12 13
14
cst 2 11 12
13 15 16
cst 3 11 12
14 15 16
cst 4 11 12 13
14

Basically, I need the sum of their last 3 consecutive order values,
starting from most recent date (from right). So for cst 1 it would be
(12+13+14) for cst2: (11+12+13), cst3: (14+15+16) and cst4:
(12+13+14).

I suppose array formula should be of help but not sure how to do it.
Any idea can I get this done?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Calculating the Average for non consecutive cells using custom for BurghRocks Excel Discussion (Misc queries) 2 October 17th 07 07:49 PM
Exclude zero values using average function in a pivot table abs Excel Discussion (Misc queries) 1 July 6th 06 12:25 PM
Average, Excluding Zeros, Non-Consecutive Range Coal Miner Excel Discussion (Misc queries) 9 August 4th 05 10:21 PM
Error Handling #N/A with AVERAGE Function - Average of values in Row Sam via OfficeKB.com Excel Worksheet Functions 13 July 31st 05 03:59 PM
Return Consecutive Values Sam via OfficeKB.com Excel Worksheet Functions 14 June 9th 05 01:21 AM


All times are GMT +1. The time now is 08:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"