Exe Calculations Sumif PDF

Preview

Summary

Download Exe Calculations Sumif PDF

Description

EXERCISE 10.5: SUM-IF FORMULA

1. Open the workbook called Calculations SCENARIO/instructions:  You would like to enter a product name into cell G4 and have Excel tell you how many of that item you have in stock. This will require a SUMIF calculation.  Sum (add) the stock amounts IF the product name matches what you have requested 2. Type a product name (one that appears in the list) into cell G4 3. Create a SUMIF calculation in H4. 4. The range will be the items in column B 5. The criteria will be cell G4 6. The sum_range will be the stock values in column C 7. Change the product name and ensure your calculations are correct 8. Save and close the Workbook as: Surname_Student No_SumIF_Your Group 9. Upload to Activity Submission Tab_All Excel Sub. Folder_Excel: Integration Folder_Link: Excel Exercise Submission 10.5 Your Solution Should Look like This, Below:

Make Apple Samsung

Product Ipad Note 3

Samsung

Screen Guard

Apple Nokia

Ipad cover Windows 10

Nokia

Lumia

Apple Samsung Apple

Screen Replacement Bluetooth Keyboard iPhone 6

Other

Charger

Stock

Price

25

R

5 000.00

17

R

11 000.00

38 15

R R

100.00 150.00

100

R

850.00

8 26 12

R R R

2 000.00 1 000.00 7 000.00

46 26

R R

10 000.00 55.00

SUM (Adding the 'Make' together/independently Apple R 16 150.00 Samsung R 18 100.00 Nokia R 2 850.00 Other R 55.00 SUM (Adding all the "Prices" less < R5000) R 4 155.00

Calculations EXAMPL E1

EXAMPL E2

EXAMPL E3

Product Note 3

Total Stock

Make Samsun g

Price R 18 100.00

Make Price

Less than R5000 R 4 155.00

17...