Isn't it just in the row below Purchased Items ($'s)

=SUM(B7:B11)

which when copied to Columns C, D & E will adjust, as it will when the
formula in B12 is copied and pasted into B26

or am I missing something?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"WRC" wrote in message
...
Need to add Qual Hardware+No Charge+DAT Hardware+Outside Lab+Purchased
Items
for all projects month wise.
All Projects are of same format (i.e they are at equally placed for ex:
gap
between proj Eng. of project 1 & Proj Eng project 2 is 14 rows.


Jan Feb Mar Apr
Project:
Proj Eng (Hrs) 1 1 1 1
Design/Drafting (Hrs) 4 4 4 4
Analysis (Hrs) 5 5 5 5
Test Tech (Hrs) 1 1 1 1
Qual Hardware ($'s) 10 10 10 15
No Charge ($'s) 6 6 6 6
DAT Hardware ($'s) 8 8 8 8
Outside Lab ($'s) 3 3 3 3
Purchased Items ($'s) 2 2 2 2

Project:
Proj Eng (Hrs) 1 1 1 1
Design/Drafting (Hrs) 4 4 4 4
Analysis (Hrs) 1 1 1 1
Test Tech (Hrs) 2 2 2 2
Qual Hardware ($'s) 3 3 3 3
No Charge ($'s) 5 5 5 5
DAT Hardware ($'s) 7 7 7 7
Outside Lab ($'s) 8 8 8 8
Purchased Items ($'s) 6 6 6 6

Project:
Proj Eng (Hrs) 2 2 2 2
Design/Drafting (Hrs) 4 4 4 4
Analysis (Hrs) 3 3 3 3
Test Tech (Hrs) 1 1 1 1
Qual Hardware ($'s) 5 5 5 5
No Charge ($'s) 6 6 6 6
DAT Hardware ($'s) 7 7 7 7
Outside Lab ($'s) 8 8 8 8
Purchased Items ($'s) 9 9 9 9
Project:
.....................
...................