Hi,

I'm looking at an array to make a sum something like this, but it's not
working. Can I get some help?

=IF($G$5:$G$67<"x",SUM(IF($C$5:$C$67="Company",($ D$5:$D$67))),0)

Column D is the amount to sum, but
Column G cannot have an 'x' beside the amount in column D to count
amount in the sum, and
Column C has to match 'Company' beside the amount in column D to count
the amount in the sum as well.

Column D is the invoice amount
Column G is x'd when it's paid
Column C is the company name
E77 is the formula showing how much company has outstanding. I get 0 &
it should be $18,850.00.

Thanks,

Michele