| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct or Sumif formula
You are welcome! Thanks for the feedback!
Stefi Peter ezt *rta: Hi Stefi Thank you for this - I was able to change the ="account" etc to cell range and works fine. I must have had brackets in wrong place - as fairly straight forward. thanks very much for your help "Peter" wrote: 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 |
| Reply |
| 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 | |||
Hybrid Mode
