SUMIF function

choungeehowe · Mar 5th, 2002, 09:39 AM

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 · Mar 5th, 2002, 09:42 AM

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

Steve Hartman · Mar 5th, 2002, 10:36 AM

Look up sumif in the Excel help files.

choungeehowe · Mar 5th, 2002, 10:41 AM

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 · Mar 5th, 2002, 10:49 AM

Quote:

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 · Mar 5th, 2002, 10:51 AM

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 · Mar 5th, 2002, 11:20 AM

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.

Steve Hartman · Mar 5th, 2002, 11:24 AM

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

Anne Troy · Mar 5th, 2002, 11:29 AM

Perhaps this will enlighten?

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

choungeehowe · Mar 5th, 2002, 11:32 AM

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

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

Mar 5th, 2002, 11:29 AM	#9
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,512	Perhaps this will enlighten? http://www.cpearson.com/excel/array.htm __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 5th, 2002, 09:39 AM	#1
choungeehowe New Member Join Date: Mar 2002 Posts: 13	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 ?

Mar 5th, 2002, 09:42 AM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	http://www.mrexcel.com/wwwboard/messages/8961.html

Mar 5th, 2002, 10:36 AM	#3
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	Look up sumif in the Excel help files.

Mar 5th, 2002, 10:41 AM	#4
choungeehowe New Member Join Date: Mar 2002 Posts: 13	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

Mar 5th, 2002, 10:51 AM	#6
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	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.

Mar 5th, 2002, 11:20 AM	#7
choungeehowe New Member Join Date: Mar 2002 Posts: 13	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.

Mar 5th, 2002, 11:24 AM	#8
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	Clicking the link gives me a page not available error. Sure the address is correct?

Mar 5th, 2002, 11:32 AM	#10
choungeehowe New Member Join Date: Mar 2002 Posts: 13	arghh... if the pic doesnt show ... its http://www.geocities.com/choungeehowe/ [ This Message was edited by: choungeehowe on 2002-03-05 10:50 ]