Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Would love some help with this. I'm not sure how to write the formulas. O'Donovan & Sullivan Law Associates BILLING SUMMARY OCTOBER 4 TO 8,

image text in transcribedimage text in transcribedWould love some help with this. I'm not sure how to write the formulas.

O'Donovan & Sullivan Law Associates BILLING SUMMARY OCTOBER 4 TO 8, 2021 3 File Client Attorney Code Billable Hours Hourly Rate 4 Date Legal Fees Billing Statistics 10/4/2021 10/4/2021 FL-325 Total Legal Fees Billed by Attorney Marty O'Donovan 26.75 6,286.25 235.00 10104 EP-652 10106 2,843.50 235.00 12.10 7,481.25 6,305.00 3,148.60 Toni Sullivan CL-412 10/4/2021 10125 33.25 225.00 2 10/5/2021 10/5/2021 10/5/2021 260.00 IN-745 EL-632 Rosa Martinez 10210 24.25 3 20.00 Kyle Williams 10225 12.11 4 10 RE-475 TOTAL $ 10285 10,152.00 4 240.00 42.30 |CL-501 11 10/6/2021 3,431.25 4,556.25 Average Billable Hours by Attorney 6,500.00 5,448.00 5.980.00 225.00 10341 15.25 12 CL-521 10/6/2021 20.25 10334 225.00 13 Marty O'Donovan PL-348 10/6/2021 260.00 10420 25.00 Toni Sullivan 14 RE-492 10/6/2021 240.00 10425 4 22.70 15 EL-632 10/7/2021 260.00 Rosa Martinez 10225 3 23.00 3 Kyle Williams 16 PL-512 10/7/2021 260.00 16.20 4,212.00 10290 4 17 IN-745 FL-385 CL-412 10/7/2021 260.00 3,770.00 10210 14.50 18 Attorney Code Table 10278 10/7/2021 5,640.00 235.00 24.00 19 Code Hourly Rate 10/8/2021 3.431.25 5,287.50 Attorney 225.00 10125 15.25 20 10/8/2021 CL-450 10358 Marty O'Donovan 235.00 2. 23.50 225.00 21 10/8/2021 Toni Sullivan IN-801 10346 260.00 3.705.00 6,175.00 14.25 225.00 22 Rosa Martinez EP-685 10/8/2021 20.00 260.00 10495 23.75 23 RE-501 10384 10/8/2021 Kyle Williams 4 13.75 240.00 3,300.00 4 240.00 24 TOTAL TOTAL $ 97,652.85 402.16 c. In the range J6:J9, calculate the total legal fees billed by attorney (use SUMIF) d. In the range J13:J16, calculate the average hours billed by attorney (use AVERAGEIF)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Economic Development Finance

Authors: Karl F Seidman

1st Edition

0761927093, 9780761927099

More Books

Students also viewed these Accounting questions