Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Correct FORMULA NEEDED PLEASE
Hi,
I am using the following formula: =SUM(H5:H12,G5:G12,F5:F12)*200000/M5:M12 The formula is giving me the wrong answer. Is this the correct formula? What I am trying to achieve is continuos information for a rolling 12 months. When I add another month all the information will change to the most current with the formula used above. Please help. Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula needed | Excel Worksheet Functions | |||
Vlookup, What is correct formula for problem below? | Excel Worksheet Functions | |||
Formula Result Correct but value in the cell is wrong | Excel Worksheet Functions |