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