SUMIF function

choungeehowe

New Member
Joined
Mar 2, 2002
Messages
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 ?
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
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
 
Upvote 0
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?
 
Upvote 0
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.
 
Upvote 0
untitled.jpg


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

Forum statistics

Threads
1,213,487
Messages
6,113,943
Members
448,534
Latest member
benefuexx

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top