No. this is the formula =SUMIF(K9:M36,J40,F9:F36) there are only three
columns for the risk criteria so range k9:m36

"Marcelo" wrote:

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.