Question: table [ [ 1 3 , PL - 3 4 8 , 1 0 4 2 0 , 1 0 1 0 ? 2

\table[[13,PL-348,10420,1010?2012,3,25.00,$100.00,2,500.00,Total Legal Fees Billed by Attorney,sumif],[14,RE-492,10425,1010?2012,4,22.70,$90.00,2,043.00,1,Marty O'Donovan,s,62.85],[15,EL-632,10225,1011?2012,3,23.00,$100.00,2,300.00,2,Toni Sullivan],[16,PL-512,10290,1011?2012,3,16.20,$100.00,1,620.00,3,Rosa Martinez],[17,IN-745,10210,1011?2012,3,14.50,$100.00,1,450.00,4,Kyle Williams],[18,FL-385,10278,1011?2012,1,24.00,$85.00,2,040.00,,TOTAL,s,62.85],[19,CL-412,10125,1012?2012,2,15.25,$75.00,1,143.75,,,,],[20,CL-450,10358,1012?2012,2,23.50,$75.00,1,762.50,Average Billable Hours by Attorney,,rageif],[21,IN-8ol,10346,1012?2012,3,14.25,$100.00,1,425.00,1,Marty O'Donovan,20.95],[22,EP-685,10495,1012?2012,3,23.75,$100.00,2,375.00,2,Toni Sullivan],[23,RE-501,10384,1012?2012,4,13.75,$90.00,1,237*50,3,Rosa Martinez],[24,,,,TOTAL,402.16,TOTAL,$ 35,798.25,4,Kyle Williams],[25,,,,,,,,,Overall Average,,]]
Using the sumif function to sum all the total legal fees billed by attorney "2" Toni Sullivan found in cell H15. The function goes in cell J15.
Description of function: =sumif(range , criteria , sum_range). Write the complete function in the field below.
Question 3(1 point)
Fill in the hlanks for the following functions using the sample Excel worksheet below.
 \table[[13,PL-348,10420,1010?2012,3,25.00,$100.00,2,500.00,Total Legal Fees Billed by Attorney,sumif],[14,RE-492,10425,1010?2012,4,22.70,$90.00,2,043.00,1,Marty O'Donovan,s,62.85],[15,EL-632,10225,1011?2012,3,23.00,$100.00,2,300.00,2,Toni Sullivan],[16,PL-512,10290,1011?2012,3,16.20,$100.00,1,620.00,3,Rosa Martinez],[17,IN-745,10210,1011?2012,3,14.50,$100.00,1,450.00,4,Kyle Williams],[18,FL-385,10278,1011?2012,1,24.00,$85.00,2,040.00,,TOTAL,s,62.85],[19,CL-412,10125,1012?2012,2,15.25,$75.00,1,143.75,,,,],[20,CL-450,10358,1012?2012,2,23.50,$75.00,1,762.50,Average Billable

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!