are you using it?

=sumif(a9:e36,"criteria",k9:m36)


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"LSalazar" escreveu:

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.