|
Posted to microsoft.public.excel.worksheet.functions
|
|
|
If cell on either side is something count in sum
Thanks! Both options work.
Max wrote:
=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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mjones" wrote:
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
|