If cell on either side is something count in sum

[mjones]

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

 

[Guest]

Hi, Michelle,

This is a straightforward syntax matter. In the end, you want to perform
the SUM, so the SUM should be the outsidemost function, with the nested IF
statements inside, like this:

=SUM(IF(condition,true,if(condition,true,false),false))

Notice the symmetry if you read it from the center out? It has been about
25 minutes since you posted, so you might have noticed this yourself by now.

Regards,
Marty S.

 

[Guest]

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

One way is to use SUMPRODUCT
Try, normal ENTER will do:
=SUMPRODUCT(($G$5:$G$67<>"x")*($C$5:$C$67="Company"),$D$5:$D$67)

 

[mjones]

Thanks! Both options work.

One way is to use SUMPRODUCT
Try, normal ENTER will do:
=SUMPRODUCT(($G$5:$G$67<>"x")*($C$5:$C$67="Company"),$D$5:$D$67)

 

[Max]

Glad it did!
Thanks for feedback