Member Avatar for leecker
leecker 0 Newbie Poster

I need to average the last 4 data points in a row, i can do it in columns but not rows. Here is what I have (This is using "SUM" I can replace with "AVERAGE")

B C
1
2 Month Qty Months Total
3 Jan-10 10 3 240
4 Feb-10 20 =SUM(OFFSET(C2,COUNT(C:C)-E3+1,0,E3,1))
5 Mar-10 30
6 Apr-10 40
7 May-10 50
8 Jun-10 60
9 Jul-10 70
10 Aug-10 80
11 Sep-10 90

This works for columns, how can I get it for rows?

Edited by leecker because: Explained SUM vs AVG
  • 1 Contributor
  • 0 Replies
  • 67 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.