 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008Sumproduct error
Hi! I have a formula that work fine on a computer, but on other computer (same software installed) it return #VALUE. Formula is: =SUMPRODUCT(--(Export!$G$2:$G$100>C9);--(Export!$G$2:$G$100<D9);--(Export!$D$2:$D$100)) Can anybody help? Thanks Both using ; ??  SignatureDon Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com > Hi! > [quoted text clipped - 4 lines] > Can anybody help? > Thanks Yes, both. And I don't understand why is working on a computer and not on other. Same software installed, same settings. > Both using ; ?? > > Hi! [quoted text clipped - 5 lines] > > Can anybody help? > > Thanks It is probably an error in the data. Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Yes, both. And I don't understand why is working on a computer and not on > other. [quoted text clipped - 10 lines] >> > Can anybody help? >> > Thanks Do you have any errors in those ranges? Do you have any non-numeric data in Export!D2:D100? Maybe trying this version: =SUMPRODUCT(--(Export!$G$2:$G$100>C9); --(Export!$G$2:$G$100<D9); (Export!$D$2:$D$100)) I'm not sure why you wanted those double minuses in front of the last portion. > Hi! > [quoted text clipped - 4 lines] > Can anybody help? > Thanks SignatureDave Peterson Hello! There is no non-numeric data in Export!D2:D100. And no, I have no errors in those range. I've tried the same formula on Excel2007 and it work too. If you think it helps I can send you the file. Thanks. > Do you have any errors in those ranges? > [quoted text clipped - 16 lines] > > Can anybody help? > > Thanks No thanks to the offer of the workbook. But I'd look again for non-numeric data in that range. Maybe you have hidden rows (filtered???). Or maybe you have errors in one of those ranges. > Hello! > [quoted text clipped - 31 lines] > > > > Dave Peterson SignatureDave Peterson Sorry for late answer. It works when I put =SUMPRODUCT(--(Export!$G$2:$G$100>C9); --(Export!$G$2:$G$100<D9); (Export!$D$2:$D$100)). Thanks a lot! Best regards, Constantin. > No thanks to the offer of the workbook. > [quoted text clipped - 38 lines] > > > > > > Dave Peterson That means that you have some non-numeric data in D2:D100. You may want to double check to see if that's what you intended. > Sorry for late answer. > [quoted text clipped - 53 lines] > > > > Dave Peterson SignatureDave Peterson > Hi! > > I have a formula that work fine on a computer, but on other computer (same > software installed) it return #VALUE. Formula is: > =SUMPRODUCT(--(Export!$G$2:$G$100>C9);--(Export!$G$2:$G$100<D9);--(Export!$D$2:$D$100)) There appears to be no valid reason for a different behavoir in two similar computers, except that computers are sometimes a strange mixture of hardware and software. Did you try this? =SUMPRODUCT((Export!$G$2:$G$100>C9)* (Export!$G$2:$G$100<D9)* (Export!$D$2:$D$100)) Bruno
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.