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

Formula result showing 0
 

Try
=SUMPRODUCT((Overall!$J$2:$J$1229=Summary!A2)*(Ove rall!$D$2:$D$1229))

OR array entered. Please note that this is an array formula. You create
array formulas in the same way that you create other formulas, except you
press CTRL+SHIFT+ENTER to enter the formula. If successful in 'Formula Bar'
you can notice the curly braces at both ends like "{=<formula}"

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

--
Jacob


"Rajula Luke - This is my display name" wrote:

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

Formula result showing 0
 

Try

=SUMIF(Overall!$J$2:$J$1229,Summary!A2,Overall!$D$ 2:$D$1229)


--

HTH

Bob

"Rajula Luke - This is my display name"
ft.com wrote in message
...
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

Formula result showing 0
 

or simply click on formula and then press ctrl+shift+enter.

"Rajula Luke - This is my display name" wrote:

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