MSFN Forum: Excel problem - MSFN Forum

Jump to content



Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Excel problem Rate Topic: -----

#1 User is offline   damo12 

  • Junior
  • Pip
  • Group: Members
  • Posts: 50
  • Joined: 12-October 04

Posted 28 November 2006 - 04:30 PM

I am using Excel 2003 to record irrigation water usage (see attached file). I want to be able to calculate the total and average water usage for each section that is being irrigated. Does anyone know how to do this?

Attached File(s)



#2 User is offline   Anne Troy 

  • Junior
  • Pip
  • Group: Members
  • Posts: 69
  • Joined: 22-February 06

Posted 03 December 2006 - 12:27 AM

No formulas necessary.

Use Data-->Subtotals as per my article:
http://www.officearticles.com/excel/gettin...osoft_excel.htm

See attached file.
Click the 2 at the upper left of the spreadsheet to see total and average detail.
Click the 3 to see total and average ALL.

Attached File(s)


Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users



All trademarks mentioned on this page are the property of their respective owners
Copyright © 2001 - 2011 msfn.org
Privacy Policy