LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Deb
 
Posts: n/a
Default help creating average formula

I have a spreadsheet that has 29 clients information for the year 2004,
broken down by month and they've asked me to average out collections,
services provided etc. I need to have this reflect the average per month.

I first tried totalling all columns and then put basic average formula like
this in =average(d4:d541) and figured, but I'm not sure that using this
formula has given me the average per month. Would this have given me the
average per month for the entire year?

Thanks in advance for your help
 
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
Creating a check mark box MarthaSue Setting up and Configuration of Excel 18 April 28th 05 12:31 AM
Named SUM Formula with relative refernce(s) Werner Rohrmoser Excel Worksheet Functions 2 April 20th 05 04:56 PM
Compounded formula using SUM & AVERAGE WIZPRO Excel Worksheet Functions 1 April 6th 05 06:05 PM
Creating a formula using absolute referencing - I think!! Victoria Excel Worksheet Functions 4 February 26th 05 08:13 PM
revert formula insertion to old method Don't be a pain in the ass Setting up and Configuration of Excel 0 January 24th 05 01:49 PM


All times are GMT +1. The time now is 09:54 AM.

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"