Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sub Total Cost by MFG
When I make an order sheet have a QTY collumn, a Model collumn, a Manufacturer collum, a net collum, a freight collum, etc. Is there a way to set up a cell that will seach for all items in the list made by MFG "So and so" and then calculate the total amount that is being spent by adding up my net cost and frieght for each of the items??? -- lax58 ------------------------------------------------------------------------ lax58's Profile: http://www.excelforum.com/member.php...o&userid=24688 View this thread: http://www.excelforum.com/showthread...hreadid=382586 |
#2
|
|||
|
|||
Check the help file for SUMIF
SUMIF Adds the cells specified by a given criteria. Syntax SUMIF(range,criteria,sum_range) "lax58" wrote: When I make an order sheet have a QTY collumn, a Model collumn, a Manufacturer collum, a net collum, a freight collum, etc. Is there a way to set up a cell that will seach for all items in the list made by MFG "So and so" and then calculate the total amount that is being spent by adding up my net cost and frieght for each of the items??? -- lax58 ------------------------------------------------------------------------ lax58's Profile: http://www.excelforum.com/member.php...o&userid=24688 View this thread: http://www.excelforum.com/showthread...hreadid=382586 |
#3
|
|||
|
|||
Check out the SUMIF() function in the Help feature. Note that spelling
matters! "William Smith Manufacturing" is different from "Wm Smith Mfg", and "ABC Co" is different from "A BC Co". If I can suggest, develop a subtotal by manufacturer and then compare the total of manufacturers to the original list of items. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to total itmes if they fall between a date range | Excel Worksheet Functions | |||
How to total items if they fall between a date range | Excel Discussion (Misc queries) | |||
GetPivotData does not return total values | Excel Worksheet Functions | |||
Total remaining formula | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |