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