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
|