P
Peter
Hi all
I am looking for a formula that looks at col a and col b and where the same
total col c.
Account No Month End Date Balance
INTE08 28/02/2009 £1,000.00
INTE08 28/02/2009 £1,000.00
INTE08 31/03/2009 £1,000.00
INTE08 31/03/2009 £1,000.00
INTE07 30/04/2009 £1,000.00
INTE07 30/04/2009 £1,000.00
So - where Account No and Month End = Inte08 and 28/2/09 then total balance
= £2000.
I have had a quick look at sumproduct formula but keep getting Value#
(array) or non array.
Any ideas would be greatly appreciated
Thanks
Peter
I am looking for a formula that looks at col a and col b and where the same
total col c.
Account No Month End Date Balance
INTE08 28/02/2009 £1,000.00
INTE08 28/02/2009 £1,000.00
INTE08 31/03/2009 £1,000.00
INTE08 31/03/2009 £1,000.00
INTE07 30/04/2009 £1,000.00
INTE07 30/04/2009 £1,000.00
So - where Account No and Month End = Inte08 and 28/2/09 then total balance
= £2000.
I have had a quick look at sumproduct formula but keep getting Value#
(array) or non array.
Any ideas would be greatly appreciated
Thanks
Peter