# 3 conditional sum s per page over 15 pages

#### A1058

##### New Member
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

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
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)

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

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?

Replies
1
Views
245
Replies
24
Views
747
Replies
5
Views
377
Replies
13
Views
236
Replies
0
Views
774

1,217,455
Messages
6,136,749
Members
450,025
Latest member
Beginner52

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back