Solved

Excel - Why isn't this formula working?

Posted on 2011-09-20
2
161 Views
Last Modified: 2012-06-21
Hi Excel Experts,

How come this formula works in one of my workbooks but not another?

 Combined-Inventory-09-30-10-New.xlsx Combined-Inventory--August-2011-.xlsx

 Works Here Not Working

I am trying to do a fairly simple formula:  =SUM(($C$4:$C$1272=$C$1275)*($Q$4:$Q$1272))

Whenever I put it in, i get #Value.

Why?
0
Comment
Question by:activematx
2 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 36570064
That's an "array formula" - you need to enter it and then confirm with CTRL+SHIFT+ENTER

To do that press F2 key to select formula then hold down CTRL and SHIFT keys and press ENTER so that curly braces like { and } appear around the formula in the formula bar.

It's simpler, though, in this case to use a non-array SUMIF formula to get the same result, i.e.

=SUMIF($C$4:$C$1272,$C$1275,$Q$4:$Q$1272)

regards, barry
0
 
LVL 9

Author Comment

by:activematx
ID: 36570190
Thanks so much Barry!  You saved me so much time!
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now