#value error?

K

kp0250

I keep getting a #value error and i'm not sure why?
=SUM(IF(Capitol!$B$13:$B$15=$L$4,IF(Capitol!$C$13:$C$15=$L$5,IF(Capitol!$D$13:$D$15=$L$6,IF(Capitol!$A$13:$A$15,1,0)))))

Thanks for any help
 
G

Gord Dibben

This looks like an array formula.

F2 then CTRL + SHIFT + ENTER

Excel will put { } around it.


Gord Dibben MS Excel MVP
 
T

T. Valko

In addition...

What are you attempting to do with the last IF:

....IF(Capitol!$A$13:$A$15,1,0)...

If there are any TEXT entries in that range you'll also get the #VALUE!
error.

You can do this with a normally entered formula. The "blank area" at the end
is for whatever IF(Capitol!$A$13:$A$15 is supposed to do/mean.

=SUMPRODUCT(--(Capitol!$B$13:$B$15=$L$4),--(Capitol!$C$13:$C$15=$L$5),--(Capitol!$D$13:$D$15=$L$6),--(............))
 
D

daddylonglegs

That formula needs "array entering", i.e. confirmed with CTRL+SHIFT+ENTER so
that curly braces appear around the formula, have you done that?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

=sum(if HELP!!!!!!!!! 0
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Adding sequence numbers to paragraphs 0
Numbers from first column 6
tiny discrepancies in fixed-point numbers 3
Nested IF & Nested AND 2
Average problem 1
Formula help with greater than and count if 1

Top