I am using the SUMIF function to figure out the instances of a risk factor.
the range of the risk factors span across three columns (K9:M36). the
criteria is from A to E and it's looking at another column to add the value
based on the risk factor. the formula now is only looking at values in column
K and M and 'ignoring' the middle column. is there a fix for this? any help
would be greatly appreciated.