bluepenink
Well-known Member
- Joined
- Dec 21, 2010
- Messages
- 585
hello all
can someone tell me why this formula i have is not working?
=IF(OR(ROW()-12>SUM(DistrictSum),ROW()-12>SUM(AEDistSum)),"",LEFT('- "District" -'!$A$3,1)&'- "District" -'!$C$3&LEFT('- "District" -'!$A$4,1)&'- "District" -'!$C$4)
it works fine with (districtsum)
but when i include the "OR" statement for it to check in another worksheet range "AEDistSum" it does not pull all the numbers.
any suggestions?
can someone tell me why this formula i have is not working?
=IF(OR(ROW()-12>SUM(DistrictSum),ROW()-12>SUM(AEDistSum)),"",LEFT('- "District" -'!$A$3,1)&'- "District" -'!$C$3&LEFT('- "District" -'!$A$4,1)&'- "District" -'!$C$4)
it works fine with (districtsum)
but when i include the "OR" statement for it to check in another worksheet range "AEDistSum" it does not pull all the numbers.
any suggestions?