This looks like an array formula.

F2 then CTRL + SHIFT + ENTER

Excel will put { } around it.


Gord Dibben MS Excel MVP

On Sun, 27 Jul 2008 12:08:59 -0700, kp0250
wrote:

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