Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
widman
 
Posts: n/a
Default

Sounds like you just need the SUMIF function.
As an example, I use it for petty cash. The person in charge just fills out
the expenses, as many as there are in a day. The column at the right (that
could have been another page) has 31 days in it, with the total outflow per
day. SUMIF looks to see where the day spent column matches the number to its
left, and then sums the column with the amount.
They also enter the account number, so on another sheet, it summarizes the
total month to date in each of 70 or so accounts.

"Jay" wrote:

I have a daily print log w/ 6 columns that record: date, client name,
printer's initials and three columns pertaining to sheet size. This
is working well on a daily basis as the number of sheets in a
particular size are continuously added as the month and list go on.
At the end of the month I need to consolidate the list in order to
bill the clients. Some of the clients names (print orders) will show
up numerous times. Some names are new clients, etc..

Question is: Besides using filters on the same sheet, how can I make a
consolidated list that will show the clients name only once, along
with a single sum representing the amount of sheets printed in a
particular size. How can I get excel to recognize text entries that
match other entries, so that in the end it will only list that
particular name once.


Maybe a pivot table report would meet your needs:
Data Pivot table report

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
Extract multiple records matching criteria from list William DeLeo Excel Worksheet Functions 12 June 30th 05 02:35 PM
Can I extract text as a value from a formula? Amy O Excel Worksheet Functions 2 January 8th 05 12:41 AM
Make a text file from Excel workbook Ramana Murthy Excel Discussion (Misc queries) 7 January 3rd 05 05:37 PM
Macro or Function to make text size to suite text Length? lbbss Excel Discussion (Misc queries) 4 December 14th 04 07:53 PM
How to Make the text blink in Excel? rajesh aiyappa Excel Worksheet Functions 3 October 29th 04 09:24 PM


All times are GMT +1. The time now is 06:59 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"