Question: 1 In this spreadsheet, which function will sum only the values from column B that cost more than $40? A B 1 Expense Amount 2

1 In this spreadsheet, which function will sum only the values from column B that cost more than $40? A B 1 Expense Amount 2 screwdrivers $68.00 3 hammers $30.00 4 pliers $55.00 5 wrenches $41.00 6 nails $22.00 7 duct tape $18.00 8 saw $79.00 9 files $45.00 10 paint $90.00 11 bolts $19.00 12 brushes $33.00 B: =SUMIF(B2:B12,"40")

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