Thanks:  0
Likes:  0

1. i have a question ... i have an assignment to do and this is what it asked me to do.
Create a Summary worksheet containing:
Total Costs and Total Profits for A course
Total Costs and Total Profits for B course.
use the SUMIF function to calculate these costs

how do i use SUMIF?? i mean i can probably just use SUM function to calculate it ... but the course guide ask me to use SUMIF ... anyone ?

2.

3. Look up sumif in the Excel help files.

4. i dont quite understand the excel help. cuz using the SUMIF function .. it'll sum up the figures if i put something for the function to compare ... but the thing is ... i have nothing to compare ... and i can only use the SUM function to total up the costs and profits. so it's either my course guide is telling me to put the wrong function or ... theres something for me to put in my sheet in order for the SUMIF to lookup to

5. On 2002-03-05 08:39, choungeehowe wrote:
i have a question ... i have an assignment to do and this is what it asked me to do.
Create a Summary worksheet containing:
Total Costs and Total Profits for A course
Total Costs and Total Profits for B course.
use the SUMIF function to calculate these costs

how do i use SUMIF?? i mean i can probably just use SUM function to calculate it ... but the course guide ask me to use SUMIF ... anyone ?
Care to provide 10 rows of data which you're supposed to summarize per course?

Since you are creating a summary sheet, I assume you have a bunch of data on another sheet? You would use SUMIF on your summary sheet and it would reference the data on the other sheet.

7. sorry if its too much trouble. heres the spreadsheet. http://www.geocities.com/choungeehow...ways_right.xls

under the 'Summary' sheet . I have put in my total there using the SUM function. But my course guide wants me to use the SUMIF. So from there i dont know how to use the SUMIF function.

8. Clicking the link gives me a page not available error. Sure the address is correct?

9. Perhaps this will enlighten?

http://www.cpearson.com/excel/array.htm

10. arghh... if the pic doesnt show ... its http://www.geocities.com/choungeehowe/

[ This Message was edited by: choungeehowe on 2002-03-05 10:50 ]

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•