SUMIF function

[choungeehowe]

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 ?

 

[Brian from Maui]

http://www.mrexcel.com/wwwboard/messages/8961.html

 

[Steve Hartman]

Look up sumif in the Excel help files.

 

[choungeehowe]

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

 

[Aladin Akyurek]

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?

 

[Steve Hartman]

Could you give a little more info on how your sheets are laid out?

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.

 

[choungeehowe]

sorry if its too much trouble. heres the spreadsheet. http://www.geocities.com/choungeehowe/MBK901_always_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.

 

[Steve Hartman]

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

 

[Anne Troy]

Perhaps this will enlighten?

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

 

[choungeehowe]

arghh... if the pic doesnt show ... its http://www.geocities.com/choungeehowe/
This message was edited by choungeehowe on 2002-03-05 10:50