Search results

Perfect!! Your SUMPRODUCT formula is doing exactly what i want it to. Thank you for your help it is much appreciated.

I am having trouble trying to solve a formula requirement. I want my formula to give me the sum of a column if two criterea's are met. (i.e if column A = "CAS" and column B = "AUTO" then give me the total of column K). However it seems when using an array formula I can only select the...