belly0fdesir
05-16-2007, 04:50 PM
This is probably a rather simple question for this forum, but I've tried getting it answered on other forums, but I've gotten further, I think, on my own. I started with:
=IF(F4="","",SUM(
IF('[LOG SHEET 2007.XLS]January'!$B$2:'[LOG SHEET 2007.XLS]December'!$B$341>0,
IF('[LOG SHEET 2007.XLS]January'!$C$2:'[LOG SHEET 2007.XLS]December'!$C$341="",
'[LOG SHEET 2007.XLS]January'!$W$2:'[LOG SHEET 2007.XLS]December'!$X$341))))
Which just looked all wrong to me to begin with. I figured out that if I were just working with sheets WITHIN my current workbook, I could get it to work using the method shown below, but as soon as I try to get the formula to work with the data in the other workbook, I get a #REF! error. Can someone tell me what is wrong with the formula shown below and what is the proper way to accomplish my goal?
=SUM(
IF('[LOG SHEET 2007.XLS]January:December'!$B$2:$B$600>0,
IF('[LOG SHEET 2007.XLS]January:December'!$C$2:$C$600="",
'[LOG SHEET 2007.XLS]January:December'!$W$2:$X$600)))
i think i'm closer, but just can't get it to work for me :/
=IF(F4="","",SUM(
IF('[LOG SHEET 2007.XLS]January'!$B$2:'[LOG SHEET 2007.XLS]December'!$B$341>0,
IF('[LOG SHEET 2007.XLS]January'!$C$2:'[LOG SHEET 2007.XLS]December'!$C$341="",
'[LOG SHEET 2007.XLS]January'!$W$2:'[LOG SHEET 2007.XLS]December'!$X$341))))
Which just looked all wrong to me to begin with. I figured out that if I were just working with sheets WITHIN my current workbook, I could get it to work using the method shown below, but as soon as I try to get the formula to work with the data in the other workbook, I get a #REF! error. Can someone tell me what is wrong with the formula shown below and what is the proper way to accomplish my goal?
=SUM(
IF('[LOG SHEET 2007.XLS]January:December'!$B$2:$B$600>0,
IF('[LOG SHEET 2007.XLS]January:December'!$C$2:$C$600="",
'[LOG SHEET 2007.XLS]January:December'!$W$2:$X$600)))
i think i'm closer, but just can't get it to work for me :/