3 conditional sum s per page over 15 pages

A1058

New Member
Joined
Sep 13, 2006
Messages
46
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

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

macajm

New Member
Joined
Oct 21, 2005
Messages
32
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

New Member
Joined
Oct 21, 2005
Messages
32
:oops:
Sorry slight correction:-
BK9=BJ9*(len(L6)>0) and
BK22=BJ22*(len(L19)>0) and
BK35=BJ35*(len(L32)>0)
 

A1058

New Member
Joined
Sep 13, 2006
Messages
46
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?
 

Forum statistics

Threads
1,136,601
Messages
5,676,732
Members
419,648
Latest member
jmuench

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top