Hi Mike H

This didn't do what I needed it to do; see the other responses to this
question...I don't understand the syntax with the dashes inside the brackets,
but it seems to work.

I checked the Help again after getting this guidance, I would never have
gotten this syntax or anything close from the formula help within Excel. In
fact the description of the function would not have made me even look at that
one.

Thanks again for your input
Have a great day
--
herkimer


"Mike H" wrote:

Use sumproduct

=SUMPRODUCT((A1:A12="Name")*(B1:B12=123456)*(C1:C1 2))

Mike

"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