• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 174
  • Last Modified:

Excel - Why isn't this formula working?

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
activematx
Asked:
activematx
1 Solution
 
barry houdiniCommented:
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
 
activematxAuthor Commented:
Thanks so much Barry!  You saved me so much time!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now