Posted to microsoft.public.excel.misc

Rajula Luke - This is my display name is offline

external usenet poster

Posts: 2

Formula result showing 0

Hello,

I have entered a SUM formula. The cell shows 0 value for all the rows. When
i click on the Function Argument, i can see the actual result. How can i
refresh to show the correct result?

Formula entered is
=SUM((Overall!$J$2:$J$1229=Summary!A2)*(Overall!$D $2:$D$1229))

Help appreciated.

Thanks
Rajula

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Switching Between Showing Formula Or Actual Result In A Cell ?	Robert11	New Users to Excel	4	December 29th 06 02:53 PM
Formula Showing In A Cell Instead of Proper Result	DanK	New Users to Excel	2	March 4th 06 06:46 AM
VLOOKUP result is not showing up - only the formula	Linda	Excel Worksheet Functions	10	December 21st 05 06:37 AM
formula in cell not showing result	Leolin	Excel Worksheet Functions	8	March 18th 05 05:36 PM
Formula result not showing in cell	Leolin	Excel Worksheet Functions	2	March 17th 05 06:03 AM

All times are GMT +1. The time now is 10:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us