You can't see exactly what each value is but you can hit ctl+` to show all of
the formulas which will let you see the references. But it looks like you
have an array formula and are forgetting to ctl+shift+enter to close the
formula. Try that.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Richhall" wrote:

Hi

I have a formula:

=SUM(IF('Jan 08'!$B:$B="Day",IF('Jan 08'!$E:$E=A3,'Jan 08'!F:F,0),0))

and this is returning me a value of 0 when it should be 2. Is there a
way I can see step by step what Excel is calculating for each part of
my statement to see what it is doing?

Cheers

Rich