| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
averging prices real problem
Hi
I had not seen clearly from your original message that you had sold any shares. If you use Negative numbers for the Sales, then with Microsoft held in F1, change the formula I gave you to =(SUMPRODUCT(--(A1:A5=F1),B1:B5,C1:C5)+SUMPRODUCT(--(A1:A5=F1),B1:B5,D1:D5))/SUMIF($A$1:$A$5,F1,$B$1:$B$5) and you will get the answer of 47.5 Regards Roger Govier amrezzat wrote: *the problem is *i* cant make the excel feel that i sold some shares as a result the average will be wrong*what you posted will give not correct average reconsider and come again |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make excel not round real numbers when making a histogram? | Charts and Charting in Excel | |||
| Problem With Reference Update | Excel Worksheet Functions | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
| problem office assistant | Excel Discussion (Misc queries) | |||
| Slight problem automating Excel in a service | Setting up and Configuration of Excel | |||
Threaded Mode
