For me anyway, a tad more explanation please

What have you tried and what didn't work ?

Steve

On Fri, 26 Jan 2007 00:12:03 -0000, bobby769
wrote:

what's the difference and when would I use one over the other.

I want to sum values in different worksheets that are in the same file..

A2 is "loans active"
A3 is "current"
B1 is "Credit grade A"
C1 is "Credit Grade B"

Values are in B2:C3

Thanks.