Help in formula

  • Thread starter Thread starter Geetha
  • Start date Start date
G

Geetha

i am working on 2 workbooks. For eg. 2 workbooks, Apr'08 and May'08. Sheet 1
of my both workbooks have 3 associates salary details.I wanted to sum their
salary for each month.
i have a formula in the 2nd worksheet of Apr'08, as
=sum(sheet1!salary1:salary3). this is to find the sum of the salaries of 3
associates. if i move or copy this 2nd sheet to the may sheet to find the sum
of salaries of the 3 associates in May'08, it takes the values from Sheet 1
of the April and not from MAy'08.
 
You need to strip out the book name that comes across with the formula.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top