| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Same row different Answer.
Hello from Steved
=C6+F6+I6+L6+O6+R6+U6+X6+AA6 the sum = 22645 which is correct. =IF(SUM((IF(MOD(ROW(C6:AA6),3)=0,C6:AA6)))=0,"",SU M((IF(MOD(ROW(C6:AA6),3)=0,C6:AA6)))) = 25484 which is wrong. Please what is required for the above to make it correct. Thankyou. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why is the answer to my formula double what it should be? | Excel Discussion (Misc queries) | |||
| i cant get the exact answer e.g answer is 13.49% i got 13.00% | Excel Discussion (Misc queries) | |||
| Excel Answer Wizard BROKEN | Excel Discussion (Misc queries) | |||
| Display answer only in another cell of one containing a formula | Excel Discussion (Misc queries) | |||
| coverting answer from Radian mode to degree mode | Excel Worksheet Functions | |||
Threaded Mode
