Scribd
Upload
17 views2 pages

Exercise 2.17

Uploaded by

Kunal Mehta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
17 views2 pages

Exercise 2.17

Uploaded by

Kunal Mehta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Sum If Function

Rate Week1 Week2 Week3


Emp 1 Hour 8 35 7
Emp 1 Cost 59 472 2065 413
Emp 2 Hour 30 25 10
Emp 2 Cost 1500 1200 500
Emp 3 Hour 2 5 8
Emp 3 Cost 100 500 700

Hour ? ? ?
Cost ? ? ?
Sum If Function
Rate Week1 Week2 Week3
Emp 1 Hour 8 35 7
Emp 1 Cost 59 472 2065 413
Emp 2 Hour 30 25 10
Emp 2 Cost 1500 1200 500
Emp 3 Hour 2 5 8
Emp 3 Cost 100 500 700

Hour 40 65 25
Cost 2072 3765 1613

You might also like