Thanks SOOOO much, Eric! That is exactly what I need....I think. I'll try
this and see what happens! Thanks for all your help! I'll let you know how it
goes!

Joanna

"Eric" wrote:

Somewhere along the line there has to be a number of hours to apply to the
rate?

And I'm assuming that each attorney has more than one line charge, otherwise
you could do a sort of the one line for each attorney to get your data in a
logical order without formulas.

In any event, a SUMIF function is probably your answer.

A simple example:

Col A Col B Col C Col D
1 Name Rate Hours Total
2 John $100 50 $5,000
3 Dave $50 20 $1,000
4 Dave $50 40 $2,000
5 John $100 20 $2,000
6 Total 130 $10,000

Now, below that you employ your SUMIF summaries to tie to the $10,000 total
to wind up with:

8 Dave 60 $3,000
9 John 70 $7,000
10 Total 130 $10,000

Formula in C8: =SUMIF($A2:$A5,$A8,C2:C5)
Formula in D8: =SUMIF($A2:$A5,$A8,D2:D5)

Copy C&D down to Row 9 to replicate.

Note that the spellings of "Dave" and "John" in A8 and A9 must be an exact
match to the way they're spelled in A2:A5 for this to capture the line items
properly, and you need to account for every attorney in the summary section.
Check that you captured everything in the summary by doing a total on both
sections.

Good luck!


"Joanna" wrote:

I'm working on a settlement statement that is 112 pages. Column G=the
attorneys' name and Column F=rates for the different attorneys. Different
attorneys have different rates. At the end of my statement, I have a section
that needs to tally each attorey's fee for a total. I can't come up with a
formula that will calculate this. Please help! I'm up against a hard
deadline! Thanks in advance!