|column A||column B||column C||columnD||column E|
I have something similar to the data above.
I need to, in one cell, sum up the multiple of columns C and D, if column A shows 'P'. How can I do this in one cell? Essentially a sumif, if the sum range could be CxD. I can't use another column to multiply and get a sum range as it doesn't work in my file, so it must be done in the formula.