|
|
|
|
|||||
|
|
|
|
|
|
|||
| Welcome
to Tech Support Forum home to more then 136,000 problems solved. Issues
have included: Spyware, Malware, Virus Issues, Windows, Microsoft,
Linux, Networking, Security, Hardware, and Gaming Getting your
problem solved is as easy as: 1. Registering for a free account 2. Asking your question 3. Receiving an answer Registered members: * See fewer ads. * And much more..
|
| Want to know how to post a question? click here | Having problems with spyware and pop-ups? First Steps |
|
|||||||
| Microsoft Office support MS Office support forum |
 |
|
|
LinkBack | Thread Tools |
07-30-2009, 06:09 PM
|
#1 (permalink) |
|
Registered User
Join Date: Jul 2009
Posts: 5
OS: Win XP
|
What's wrong with my formula
Where am I going wrong I have a formula that reads.
=SUMPRODUCT(--(A1:A4>B1:B4)-(C1:C4)) If I delete -(C1:C4)) I get the correct answer of 2. But if I then type in the second part of the formula for it to minus cells C1:C4 my answer should be 1 but it returns a #N/A value. Any help is very much appreciated. |
|
     
|
| Important Information |
|
Join the #1 Tech Support Forum Today - It's Totally Free!
TechSupportForum.com is a leading support website for your computer needs. We offer free, friendly and personalized computer support. Why pay to have your computer fixed when you can do it for free. Join TechSupportforum.com Today - Click Here |
|
07-31-2009, 10:30 AM
|
#2 (permalink) |
|
Registered User
Join Date: Mar 2008
Posts: 70
OS: XP SP2, Vista
|
Re: What's wrong with my formula
If you're receiving the #N/A error, then I'm guessing you have an #N/A error somewhere in C1:C4? You should try applying error handlng within column C. If you need more help, please provide the data (including formulas) you're using in column C. A description of what you're trying to accomplish may be helpful as well.
HTH Elkar |
|
|
|
|
| Thread Tools | |
|
|
