Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11
Default Adding/Analyzing Data From One Worksheet to Another

I am making a report to track the sales steps and processes for a car lot.
The log has been set up with all of the different columns that I need. I
would like for the second page of the workbook to analyze/add the data and
statistics that will be entered into the log. My question is, how do I make
it do that?!? More specifically, if I want to say, "Add up all of the
customer statements taken by Denise from the sheet named "Sept 06", and that
data can be found from F3 through F5, and the salesperson's name can be found
from C3 through C55. I'm not sure of what formula to use, or how to set it
up to pull from the previous page. Thanks!!!
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 195
Default Adding/Analyzing Data From One Worksheet to Another

Hi,

Try using SUMPRODUCT something like this

=SUMPRODUCT((Sept 06!A3:A55="Denise)*(Sept 06!C3:C55))

Array enter the formula. <CTRL<SHIFT<ENTER

Hope this will work for you.


Thanks,

Shail


Leslie M wrote:
I am making a report to track the sales steps and processes for a car lot.
The log has been set up with all of the different columns that I need. I
would like for the second page of the workbook to analyze/add the data and
statistics that will be entered into the log. My question is, how do I make
it do that?!? More specifically, if I want to say, "Add up all of the
customer statements taken by Denise from the sheet named "Sept 06", and that
data can be found from F3 through F5, and the salesperson's name can be found
from C3 through C55. I'm not sure of what formula to use, or how to set it
up to pull from the previous page. Thanks!!!


Reply
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
Look up Data from Worksheet within same Workbook Max Excel Discussion (Misc queries) 0 May 10th 06 06:50 AM
Ignoring Rows When Extracting Data From One Worksheet To Another Jim J. Excel Worksheet Functions 2 May 8th 06 04:55 PM
Saving data in a worksheet within a workbook Homeuser Excel Discussion (Misc queries) 2 August 21st 05 10:49 PM
Inserting Filtered RC cell information into other worksheets Dennis Excel Discussion (Misc queries) 10 July 30th 05 01:54 AM
Macro to search for and display data in another worksheet Mark H Excel Worksheet Functions 0 June 14th 05 12:40 PM


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

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

About Us

"It's about Microsoft Excel"