i need to total the freight from the USD accounts only as well

All USD accounts or just those that are type "sales" ?

As long as the location of "freight" has a consistent offset, 1 row below, 2
columns to the right.

Array entered** :

=SUM(IF(A2:A16="USD",OFFSET(A2:A16,1,2)))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Picman" wrote in message
...
That worked fine. Thanks. My problem is now i need to total the freight
from
the USD accounts only as well. I'm thinking some sort of offset?


My problem now is that i want to total the feight based on the same
criteria


"porter444" wrote:

Try this:
=SUMPRODUCT(--(A3:A21="USD"), --(B3:B21="Sales"),--(C3:C21))


To learn more about SUMPRODUCT, check out this page:
http://www.contextures.com/xlFunctio...tml#SumProduct


--
If my posting was helpful, please click the "Yes" button.

ROCK ON!,

Scott