#1
|
|||
|
|||
SUM IF AND --> #value!
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. |
|