Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct or Sumif formula
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif, SumProduct, CountIf Formula Help | Excel Discussion (Misc queries) | |||
sumif/sumproduct formula help | Excel Worksheet Functions | |||
sumproduct or sumif formula help | Excel Discussion (Misc queries) | |||
Which formula to use? countif, sumif, sumproduct | Excel Discussion (Misc queries) | |||
SumIf/SumProduct Formula Help | Excel Worksheet Functions |