Multiple Criteria SUMPRODUCT Formula

Hi All

This is driving me mad, I hope someone can help. If I can just explain What I am hoping to get from this.

Column V = "Yes"
Looking up Values in the range C53 to C67 in column "I" should result in an error
Column K must not contain "016" or "833"

All of these criteria must be true and if they are then it should sum column AA

Please Login or Register  to view this content.

The formula does not produce an error but seems to be working on an OR as it is summing values where some of the criteria have not been passed.

If anyone can help or point me in the right direction then I would be most grateful.

Best Regards

Jim

"016*", "833*"

Are the * supposed to be wildcards?

If so, SUMPRODUCT doesn't support the use of wildcards.

Can you post some sample data of what is in column K?

016 is a TEXT string while 833 is a number.

If column K contains a mix of text and numbers this could get confusing!

Good deal. Thanks for the feedback!