Hi,

Is there anyone out there having the same problem as what i'm facing.

Seem like microsoft excel cannot check for 2 condition range.

my code is

=SUM(IF(AND(A9:B18=10001, E7:V7="Monday", E9:V18,0))

which give me #value!.


I have tried keying in =SUM(IF(AND(A9=10001, E7:V7="Monday", E9:V18,0)) which work but it is not the right range that I want.

Please advises.

Thanks.