Sub Total Cost by MFG

[lax58]

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???

[bigwheel]

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
>
>

[Dave O]

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.