IF / OR & Sum Statement Help

[EmmaFos]

Hi
Really hoping some awesome individual might be able to help me with my below formula,

I need to look at multiple rows in another workbook and if a cell =1, then divide I17 in original worksheet by the sum of workbook 2's numbers.

=IF(OR('[Workbook2.xlsx]BLD 21'!AP$8=1,IF('[Workbook2.xlsx]BLD 21'!AP$17=1)),$I17/SUM('[Workbook2.xlsx]BLD 21'!$AS$8:$FH$8,'[Workbook2.xlsx]BLD 21'!$AS$17:$FH$17),"","")

This formula works perfectly if I only need to look at a single row... it's adding additional rows that has me stumped!

=IF('[Workbook2.xlsx]BLD 21'!AP$41 =1,$I6/SUM('[Workbook2.xlsx]BLD 21'!$AS$41:$FH$41),"")

Thanks so much for your help!

 

[maabadi]

Are you Tested it with Ctrl+Shift+Enter

 

[Fluff]

How about

=IF(OR('[Workbook2.xlsx]BLD 21'!AP$8=1,'[Workbook2.xlsx]BLD 21'!AP$17=1),$I17/SUM('[Workbook2.xlsx]BLD 21'!$AS$8:$FH$8,'[Workbook2.xlsx]BLD 21'!$AS$17:$FH$17),"")

 

[EmmaFos]

Thanks you so much, this works perfectly!
I have just been thrown another curve ball with the data, instead of summing all the cells together. is there a way I can do a count of how many cells across the data is contained in? I.e if two rows have data in adjacent columns have 2 each, can I ignore the second set of 2? This one is totally out of my skill level!

Thanks again

 

[Fluff]

I'm afraid I have no idea what you are saying, but as this is now an obviously different question, it's better if you start a new thread.

 

[EmmaFos]

Thanks, I'll create a new thread and supply the example

 

[Fluff]