TK,

Tks for your reply but what if I want a "OR" condition. If the day=sunday or
city = west sum the values in colum L.

--
Bruce DiPaola


"T Kirtley" wrote:

For multiple criteria you cannot use the SUMIF() function.

Presuming that your named ranges are all the same shape you can use the
SUMPRODUCT()function as follows:

=SUMPRODUCT(1*(Day="Sunday"),1*(City="West"),ColmL )

Alternately, you could use an array formula like the following:

{=SUM(IF((Day="Sunday")*(City="West"),ColumL))}

which must be entered using a Ctrl^Shift^Enter key combination. This creates
the bracket characters which are not entered by you

HTH,

TK

"Bruce D." wrote:

Hello all,

I have the following formula using 3 name arrays of Day,City,columL.
ColumL is a sum of L11:L19. I am receiving the #Value error. I've tried
every way I know to solve this. Any ideas??

=SUM(AND(Day,"=Sunday",City,"=West",columL)).

The below formula works but I can't seem to get the second condition to work.

=SUMIF(Day,"=Sunday",columL)


Thanks to all who take the time to answer!!!!!

BD