| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum + IF Array wrong sum
=SUM(IF(Prod={"Product_12","Product_100"},Vol,0))
This funtion array fails to return the correct sum. The product name (Prod) column and value (Vol) column reprsents about 900 rows. The fomula returns the wrong sum when this happens. If I reduce rows to 258 or less the correct sum is returned. Is there a limitation when using arrays. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
| Array gives wrong answer | Excel Discussion (Misc queries) | |||
| Array formula returning wrong results | Excel Discussion (Misc queries) | |||
| Compound array question - what am I doing wrong? | Excel Worksheet Functions | |||
| What's wrong with my array formula | Excel Discussion (Misc queries) | |||
Threaded Mode
