But sumifs is different, it's a new function in Excel 2007 and the OP is
using it correctly

=SUMIFS(Sum_Range,Criteria_Range1,Criteria1,Criter ia_Range2,Criteria2)

I have an example using it over multiple sheet here

http://www.nwexcelsolutions.com/Excel_2007_page.htm


I remember reporting a bug back in 2006 if there were empty cells in the
criteria ranges you would get a value error and they said it would be fixed.
I don't have 2007 where I am at the moment but maybe the OP has a beta
version?



--
Regards,

Peo Sjoblom



"Bernard Liengme" wrote in message
...
SUMIF is designed to look at one range, compare it to a criteria, then sum
the range or another range.It is not able to handle two criteria; but
SUMPRODUCT is.
=SUMPRODUCT(--(C46:C77="L"),--(G46:H77="JONES"), B46:B77)

For details see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

http://mcgimpsey.com/excel/formulae/doubleneg.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"NicoleC" wrote in message
...
Price Type AGENT
$84,000.00 L JONES

All I want to do is get a sum of the price column if type=L and agent
=JONES

Here is what I have but I keep getting a Value error??

=SUMIFS(B46:B77,C46:C77,"L",G46:H77,"JONES")

I don't see what it is wrong.
I read one of the posts stating to put a value in each cell to correct
the
bug but that did not work either.