Nevermind, it did work. Must have done something wrong the 1st time.

"Teethless mama" wrote:

If you use XL-2007, you can use SUMIFS function.

"Caroline" wrote:

I want to sum amounts from one column if 2 other columns meet the criteria I
defined.
Here is what I have: =IF(AND(A:A="x",B:B=""),SUM(C:C))
Even though I have a lot of rows that match both criteria (have an "x" in
column A and nothing in column B), the formula returns "false".
Any ideas? Thanks!