3 conditional sum s per page over 15 pages

[A1058]

guys im trying to conditionally add BJ9,BJ22,BJ35 over 15 pages. ceels are all in same location on all pages using L6,L19,L32 as the trigger cells
so if L6 on any page 1-15 <> "" then sum it to page 15 BL32 <--this is destination cell for the sum... and the same for L19 and L32 if they <> "" then sum them to page 15 BL32.
hope this is clearly stated.

any help is always greatly appreciated
thanks very much

 

[macajm]

If you can enter helper cells somewhere on each sheet (using group sheet selection) such as
BK9=BJ9*(len(L6)>0) and
BK22=BJ22*(len(L6)>0) and
BK35=BJ35*(len(L6)>0)
then in cell BL32 on sheet15 you can enter the formula
=sum(Sheet1:Sheet15!BK9,Sheet1:Sheet15!BK22,Sheet1:Sheet15!BK35)

 

[macajm]

Sorry slight correction:-
BK9=BJ9*(len(L6)>0) and
BK22=BJ22*(len(L19)>0) and
BK35=BJ35*(len(L32)>0)

 

[A1058]

hey thanks for your reply : )
I looked into this a few minutes and dont think this is what i was looking for id really like to use VBA to achieve this. does anyone have any ideas on how to go about this with VBA?