Shane,

Thank you; this is very well explained. When I get Office 2007 I will keep
this in mind.

Have a great day!
--
herkimer


"ShaneDevenshire" wrote:

Hi,

If you are using 2007 you can use SUMIFS

=SUMIFS(C1:C6,A1:A6,H1,B1:B6,I1)

In this example C1:C6 is the sum range, A1:A6 is criteria range 1 and H1 is
the first condition, B1:B6 is the second criteria range and I1 contains the
second condtions.

Regardless of which formula you use it is always a good idea to use
references in them rather than hard coding them if at all possible.

If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire


"herkimer" wrote:

I am trying to do a SUMIF on a table, but I have multiple criteria in 2
columns.

The table is such that the name repeats several times, as there is another
column with account numbers in it, which in most cases also has multiple
lines. The last column holds dollar amounts.

I want to sum the dollar amounts for a specified name/account number
combination from the table. SUMIF appears to only work for one variable.

What function can I use to do this?

Thx
--
herkimer