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
|