K
KimW
Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
I originally posted this under the original SUMIFS question, but I wasn't sure anyone was monitoring it any longer, so I decided to create a new question. Sorry if this is redundant.
I am having a problem with the SUMIFS formula as well--but I am not using dates. Do you think I am having the same problem? I work with Excel 2007 for Windows, and my client who has Excel 2008 for Mac gets #VALUE in all the cells with this formula. What should he do?
=SUMIFS('Data - Data Information'!$E:$E,'Data - Data Information'!$I:$I,"FAROE ISLANDS",'Data - Data Information'!$J:$J,"BL201")
Is there another formula I can use in place of this one?
Thanks in advance.
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel
I originally posted this under the original SUMIFS question, but I wasn't sure anyone was monitoring it any longer, so I decided to create a new question. Sorry if this is redundant.
I am having a problem with the SUMIFS formula as well--but I am not using dates. Do you think I am having the same problem? I work with Excel 2007 for Windows, and my client who has Excel 2008 for Mac gets #VALUE in all the cells with this formula. What should he do?
=SUMIFS('Data - Data Information'!$E:$E,'Data - Data Information'!$I:$I,"FAROE ISLANDS",'Data - Data Information'!$J:$J,"BL201")
Is there another formula I can use in place of this one?
Thanks in advance.