View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rajula Luke - This is my display name Rajula Luke - This is my display name is offline
external usenet poster
 
Posts: 2
Default 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